Skip Menu |
 

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

Report information
The Basics
Id: 19363
Status: open
Priority: 0/
Queue: Class-DBI-Pg

People
Owner: Nobody in particular
Requestors: cushing [...] bitlathe.com
Cc:
AdminCc:

Bug Information
Severity: Critical
Broken in: (no value)
Fixed in: (no value)



Subject: Sequence setup failure with CDBI::Pg 0.08 and PostgreSQL 8.1.3
Download (untitled) / with headers
text/plain 469b
Using CDBI::Pg to set up tables in PostgreSQL breaks in certain cases. I've narrowed down the issue to what I think is a typo in the PG8.1 NextVal regexp logic. On line 60, the code currently is: $nextval_str =~ m!^nextval\(\("?([^"']+)"?'::text\)?::regclass\)!i ? I think it should be: $nextval_str =~ m!^nextval\(\('"?([^"']+)"?'::text\)?::regclass\)!i ? to match the line above it. Added the additional single quote at the start seems to fix the setup problems.
Download (untitled) / with headers
text/plain 166b
Yeah, that's a typo. Do you happen to have a test case with off hand? I don't have the time to do more than just fix that typo right now. I'll release 0.08_01 soon.
From: ohiocore [...] gmail.com
This appears to be fixed in 0.09.


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.