Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation
 
PerlMonks  

Re: Catalyst + PostgreSQL + DBIx::Class all schemas

by jasonk (Parson)
on Mar 07, 2009 at 01:00 UTC ( #748995=note: print w/replies, xml ) Need Help??


in reply to Catalyst + PostgreSQL + DBIx::Class all schemas

From the docs for DBIx::Class::Schema::Loader:

Currently the loader is limited to working within a single schema (using the database vendors' definition of "schema"). If you have a multi-schema database with inter-schema relationships (which is easy to do in PostgreSQL or DB2 for instance), you only get to automatically load the tables of one schema, and any relationships to tables in other schemas will be silently ignored.

At some point in the future, an intelligent way around this might be devised, probably by allowing the db_schema option to be an arrayref of schemas to load.

In "normal" DBIx::Class::Schema usage, manually-defined source classes and relationships have no problems crossing vendor schemas.

So it can be done, but not by DBIx::Class::Schema::Loader, and therefore not automatically.


www.jasonkohles.com
We're not surrounded, we're in a target-rich environment!
  • Comment on Re: Catalyst + PostgreSQL + DBIx::Class all schemas

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://748995]
help
Chatterbox?
[Your Mother]: Don't think so.
[Your Mother]: Windows doesn't even recognize them as far as that goes.
[Lady_Aleena]: Your Mother, thanks. I had a feeling it would be no.
[Your Mother]: :P
[Lady_Aleena]: Your Mother, it is a good thing I am no on Windows.
[Lady_Aleena]: s/no/not/;
[Lady_Aleena]: My blasted web host will not put perl 5.22 in /usr/bin/perl, it is in /usr/local/cpanel/ 3rdparty/bin/perl
Lady_Aleena has been banging her head against this wall for years now with no success on breaking the wall.

How do I use this? | Other CB clients
Other Users?
Others having an uproarious good time at the Monastery: (4)
As of 2017-04-28 06:29 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    I'm a fool:











    Results (519 votes). Check out past polls.