[Dbix-class] Cross-schema relationships.

[Rob Kinyon]

On Mon, Feb 1, 2010 at 11:52, Oleg Pronin <syber.rus at gmail.com> 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