problem after upgrading..

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

I just decided to upgrade DBD::Pg from 1.3x to 1.4x and got an error on auto-loading  with cdbi-loader i.e. :

>>>
Use of uninitialized value in split at /usr/lib/perl5/site_perl/5.8.6/Class/DBI/Pg.pm line 81.
[Wed May 25 01:48:45 2005] [error] public.category has no primary key at /usr/lib/perl5/site_perl/5.8.6/Class/DBI/Loader/Generic.pm line 174\nCompilation failed in require at (eval 11) line 1.\n
Syntax error on line 86 of /etc/apache/conf/vhosts/Vhosts.conf:
public.category has no primary key at /usr/lib/perl5/site_perl/5.8.6/Class/DBI/Loader/Generic.pm line 174
Compilation failed in require at (eval 11) line 1.
<<<

After that I put a "print" to see what fetch_array will return...

>>>
 * Starting apache...
[Wed May 25 01:46:57 2005] [error] DBD::Pg::st fetchrow_array failed: no statement executing\n [for Statement "SELECT indkey FROM pg_catalog.pg_index\nWHERE indisprimary=true AND indrelid=(\nSELECT oid FROM pg_catalog.pg_class\nWHERE relname = ?)\n" with ParamValues: 1='public.category'] at /usr/lib/perl5/site_perl/5.8.6/Class/DBI/Pg.pm line 82.\nCompilation failed in require at (eval 11) line 1.\n
Syntax error on line 86 of /etc/apache/conf/vhosts/Vhosts.conf:
DBD::Pg::st fetchrow_array failed: no statement executing
 [for Statement "SELECT indkey FROM pg_catalog.pg_index
WHERE indisprimary=true AND indrelid=(
SELECT oid FROM pg_catalog.pg_class
WHERE relname = ?)
" with ParamValues: 1='public.category'] at /usr/lib/perl5/site_perl/5.8.6/Class/DBI/Pg.pm line 82.
Compilation failed in require at (eval 11) line 1.
<<

After fidling tring to execute the query directly against Postgres.
I found that the problem is  >> ParamValues: 1='public.category' <<
If it is set to "category" instead of "public.category" then it will be succesfull.

How to solve this problem w/o modifying Class::DBI::Pg !!!

thanx alot