FAQ
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: embperl-unsubscribe@perl.apache.org
For additional commands, e-mail: embperl-help@perl.apache.org

Search Discussions

Discussion Posts

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 1 of 2 | next ›
Discussion Overview
groupembperl @
categoriesmodperl, perl
postedAug 28, '05 at 1:25p
activeNov 8, '05 at 8:30a
posts2
users2
websiteperl.apache.org

2 users in discussion

RobertCZ: 1 post Gerald Richter: 1 post

People

Translate

site design / logo © 2022 Grokbase