Re: Support for PostgreSQL schemas

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

On Tue, Jul 12, 2005 at 03:15:18PM -0400, Scott Cain wrote:
> 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?

This error doesn't come from DBIx::ContextualFetch - it looks like it's
coming from DBD::Pg. If you can make the query work with DBI itself it
should work just fine with Class::DBI/Ima::DBI/DBIx::ContextualFetch

Tony