Re: problem after upgrading..

[prev] [thread] [next] [Date index for 2005/05/24]

The code in question is set_up_table() 

>>>..............
    # find primary key
    my $sth = $dbh->prepare(<<"SQL");
SELECT indkey FROM ${catalog}pg_index
WHERE indisprimary=true AND indrelid=(
SELECT oid FROM ${catalog}pg_class
WHERE relname = ?)
SQL
    $sth->execute($table);
    my %prinum = map { $_ => 1 } split ' ', $sth->fetchrow_array;
    $sth->finish;
<<<

If I place (which of cource I dont think is solution :")) ::

$table = s/public.//;

loader-part passes, but later I get errors in the consequent parts of application... Example :

.....can't SELECT FROM category : DBD::Pg::st execute failed: ERROR: syntax error at or near "FROM" at character 9 [for Statement "SELECT FROM category "] at /usr/lib/perl5/site_perl/5.8.2/DBIx/ContextualFetch.pm line 51......................