<?xml version="1.0" encoding="windows-1252"?>
<node id="748995" title="Re: Catalyst + PostgreSQL + DBIx::Class all schemas" created="2009-03-06 20:00:53" updated="2009-03-06 20:00:53">
<type id="11">
note</type>
<author id="231445">
jasonk</author>
<data>
<field name="doctext">
&lt;p&gt;From the docs for [cpan://DBIx::Class::Schema::Loader]:&lt;/p&gt;

&lt;blockquote&gt;
&lt;p&gt;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.&lt;/p&gt;

&lt;p&gt;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.&lt;/p&gt;

&lt;p&gt;In "normal" DBIx::Class::Schema usage, manually-defined source classes and relationships have no problems crossing vendor schemas.&lt;/p&gt;
&lt;/blockquote&gt;

&lt;p&gt;So it can be done, but not by [cpan://DBIx::Class::Schema::Loader], and therefore not automatically.&lt;/p&gt;

&lt;!-- Node text goes above. Div tags should contain sig only --&gt;
&lt;div class="pmsig"&gt;&lt;div class="pmsig-231445"&gt;
&lt;hr&gt;
&lt;a href="http://www.jasonkohles.com/"&gt;www.jasonkohles.com&lt;/a&gt;&lt;br&gt;
&lt;small&gt;We're not surrounded, we're in a target-rich environment!&lt;/small&gt;&lt;br&gt;
&lt;/div&gt;&lt;/div&gt;</field>
<field name="root_node">
748933</field>
<field name="parent_node">
748933</field>
</data>
</node>
