[Catalyst] Postgresql database with non default -public- schema

[Benjamin Hitz]

I believe the repo (SVN?) version of DBIx::Class::Schema::Loader::Oracle has a fix for this.
Sorry I don't have the details right now, I have put down the dbic/catalyst pipe for a while.

Ben

On Oct 20, 2010, at 8:44 AM, Benjamin Martin wrote:

> On 20/10/10 15:22, Hetényi Csaba wrote:
>> Is this helper script capable to automatically create model for
>> the non-default tablespace?
> 
> I believe this is known issue with ::Schema::Loader.
> 
> http://search.cpan.org/~ribasushi/DBIx-Class-Schema-Loader-0.07002/lib/DBIx/Class/Schema/Loader.pm#KNOWN_ISSUES
> 
> You can sort of get around it by specifiy 'db_schema' (I think you can get it into the command line script args)
> 
> I think it works with Postgres but with Oracle it did not seem to work.. I think, regardless, you will have to manually add cross schema relationships.
> 
> Its not hard to roll your own script to build and manage your ::Result:: files... just take a peek at the ::Schema::Loader cpan docs.
> 
> _______________________________________________
> List: Catalyst at lists.scsys.co.uk
> Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
> Searchable archive: http://www.mail-archive.com/catalyst@lists.scsys.co.uk/
> Dev site: http://dev.catalyst.perl.org/

--
Ben Hitz 
Senior Scientific Programmer ** Saccharomyces Genome Database ** GO Consortium
Stanford University ** hitz at genome.stanford.edu