perl-embperl mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From RobertCZ <rob...@robert.cz>
Subject Recordset & Postgres 8 problem (and fix)
Date Sun, 28 Aug 2005 13:25:37 GMT
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


Mime
View raw message