perl-embperl mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Gavin Carr <ga...@openfusion.com.au>
Subject DBIx::Recordset and postgresql schemas?
Date Wed, 25 Aug 2004 00:43:37 GMT
I'm trying to get DBIx::Recordset to play with a PostgreSQL 8.0beta1 
install, and am getting tons of errors on my initial DBIx::Database->new
call:

    use constant DB_DSN  => 'dbi:Pg:dbname=foo';
    use constant DB_USER => 'foo';
    use constant DB_PASS => 'foo';
    DBIx::Database->new(DB_DSN, DB_USER, DB_PASS, undef, 'foo', 1);

of the form:

DBD::Pg::st execute failed: ERROR:  relation "triggered_update_columns" does not exist at
/usr/lib/perl5/site_perl/5.8.1/DBIx/Compat.pm line 33.
select * from triggered_update_columns where 1=0  failed ERROR:  relation "triggered_update_columns"
does not exist at /usr/lib/perl5/site_perl/5.8.1/DBIx/Compat.pm line 35.
DBD::Pg::st execute failed: ERROR:  relation "table_constraints" does not exist at /usr/lib/perl5/site_perl/5.8.1/DBIx/Compat.pm
line 33.
select * from table_constraints where 1=0  failed ERROR:  relation "table_constraints" does
not exist at /usr/lib/perl5/site_perl/5.8.1/DBIx/Compat.pm line 35.
<lots more snipped>

It looks like DBIx::Database->new is stripping the schema information 
from table names before calling QueryMetadata, which seems to be
required now? Anyone else seen this, or are successfully using
DBIx::Recordset with PostgreSQL 7.3+ (when schemas came in)? Or am
I missing something obvious?

Cheers,
Gavin



---------------------------------------------------------------------
To unsubscribe, e-mail: embperl-unsubscribe@perl.apache.org
For additional commands, e-mail: embperl-help@perl.apache.org


Mime
View raw message