[Dbix-class] A problem with Postgres schemas

[John Napiorkowski]

--- Rolf Schaufelberger <rs at plusw.de> wrote:

> On Thursday 28 December 2006 22:06, Kevin Esteb
> wrote:
> > I new to DBIx::Class, so please bear with me.
> >
> > I am running RHEL4 and have a postgres database
> with a schema named
> > "analog". The DBIx::Class modules are the latest
> and greatest from CPAN,
> > so is the DBD and the DBI for postgres. When I run
> the below code, I get
> > this error:
> > 
> I'm using the "on_connect_do" parameter in my
> connection setup :
> 
>  {on_connect_do => ['SET search_path TO
> analog,public']}
> 
> and can use my schemas as "normal".

Do you have any trouble with this if the tables in the
different schemas have the same name?  Or can you just
disambiguate as normal with schema.table in those
cases?

Just curious.
John

> 
> Rolf Schaufelberger
> rs at plusw.de
> 
> 
> _______________________________________________
> List:
>
http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class
> Wiki: http://dbix-class.shadowcatsystems.co.uk/
> IRC: irc.perl.org#dbix-class
> SVN:
>
http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/
> Searchable Archive:
>
http://www.mail-archive.com/dbix-class@lists.rawmode.org/
> 


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com