Re: Support for PostgreSQL schemas

[prev] [thread] [next] [Date index for 2005/07/12]

I think the error sounds more like you're returning a set (multiple 
rows) into a structure that only accepts a singleton.

I admit to knowing nothing about postgres schemas

Jay

Matt S Trout wrote:
> On Tue, Jul 12, 2005 at 03:15:18PM -0400, Scott Cain wrote:
> 
>>Hello,
>>
>>I am wondering if there is support for postgres schemas in cdbi?
>>Specifically, I have a case where there are two schemas, one called
>>public and one called godb.  In both of these schemas, there is a table
>>called 'db', and I cannot change the name of either table.  When I try
>>to use cdbi to access the db table in the public schema, I get this
>>error message:
> 
> 
> http://search.cpan.org/~dbdpg/DBD-Pg-1.41/Pg.pm#Schema_support
> 
> "Currently, DBD::Pg does not provide explicit support for PostgreSQL schemas."
> 
> This may be your problem :)
>