Skip Menu |
 

This queue is for tickets about the Class-DBI-Pg CPAN distribution.

Report information
The Basics
Id: 12154
Status: new
Priority: 0/
Queue: Class-DBI-Pg

People
Owner: Nobody in particular
Requestors: hutchinson.chris [...] gmail.com
Cc:
AdminCc:

Bug Information
Severity: Important
Broken in: 0.06
Fixed in: (no value)



Subject: sequence lookup fails on db with added dependancies
Download (untitled) / with headers
text/plain 479b
The sequence initialisation sql fails in a 8.0.1 database migrated using the 'adddepend' script to fix SERIAL dependancies. The sequence lookup uses this sql (line 103): -- SELECT adsrc FROM ${catalog}pg_attrdef WHERE adrelid=(SELECT oid FROM ${catalog}pg_class WHERE relname=?) -- Patching the statement to the below fixes the problem: -- SELECT adsrc FROM ${catalog}pg_attrdef WHERE adrelid=(SELECT oid FROM ${catalog}pg_class WHERE relname=?) and adsrc ilike 'nextval%' --


This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.