Hello,
Recordset seems to have problem with Postgres 8, probably because of
some changes in Postgres schema handling 7.4 -> 8.0 (because it works
fine with 7.4 and older versions). The problem manifests itself with
some 'no relation triggers found' (and then a lot of 'command ignored'
errors). It's because DBI->tables() returns tables from all schemas.
Quick fix is to add to Compat
sub ListTablesPg8
{
my $hdl = shift ;
return $hdl -> tables( undef, 'public' ) ;
}
and
%Compat =
...
'Pg' =>
...
'ListTables' => \&ListTablesPg8,
- Robert
PS DBI docs says
@names = $dbh->tables( $catalog, $schema, $table, $type );
@names = $dbh->tables; # deprecated
so maybe default ListTables method should be modified instead, but then
whole Recordset should be made schema-aware first I guess - should
somebody have a bit of free time... ;-)
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]