Support for PostgreSQL schemas

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

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:

DBD::Pg::st execute failed: ERROR:  more than one row returned by a
subquery used as an expression
 [for Statement "SELECT indkey FROM pg_catalog.pg_index
WHERE indisprimary=true AND indrelid=(
SELECT oid FROM pg_catalog.pg_class
WHERE relname = ?)
" with ParamValues: 1='db']
at /usr/lib/perl5/site_perl/5.8.5/DBIx/ContextualFetch.pm line 51.
Compilation failed in require at lib/Chado/LoadDBI.pm line 5.
BEGIN failed--compilation aborted at lib/Chado/LoadDBI.pm line 5.
Compilation failed in require at ./load/bin/gmod_load_ontology.pl line
7.
BEGIN failed--compilation aborted at ./load/bin/gmod_load_ontology.pl
line 7.

So it looks like DBIx::ContextualFetch is unhappy about there being two
tables named 'db'.  Is there a way around this?

Thanks,
Scott


        -- 
        ------------------------------------------------------------------------
Scott Cain, Ph. D.                                         cain@xxxx.xxx
GMOD Coordinator (http://www.gmod.org/)                     216-392-3087
Cold Spring Harbor Laboratory