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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
