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

Owner: Nobody in particular
Requestors: cushing [...]

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 [...]
This appears to be fixed in 0.09.

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

Please report any issues with to