On Mon, Feb 1, 2010 at 11:52, Oleg Pronin <[email protected]> wrote: > Hi everyone. > > I'm separating a part of database tables to second database server. > Therefore i created second schema and put a part of result sources in > there. > > I discovered that cross-schema relationships doesn't work: i get error > DBIx::Class::ResultSource::related_source(): Can't find source for > MyApp::Schema::SomeRS at ... > when i try to get related source from Schema2 to Schema > > Is there an easy way to workaround on it ? i understand that table > joins are not possible anymore, but in theory DBIC could continue to > support relationships without joins. > $obj->many_to_many_accessor->search(...), etc
How would you write the SQL to do this? Also, what RDBMS are you on? Is it Oracle? Rob _______________________________________________ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/[email protected]
