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)

History Show all quoted text
  Fri May 19 16:51:35 2006 Guest - Ticket created
Subject: Sequence setup failure with CDBI::Pg 0.08 and PostgreSQL 8.1.3
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.
  Fri May 19 21:10:56 2006 dmaki [...] cpan.org - Correspondence added
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.
  Fri May 19 21:10:57 2006 The RT System itself - Status changed from 'new' to 'open'
  Tue Jun 05 12:32:37 2012 ohiocore [...] gmail.com - Correspondence added
From: ohiocore [...] gmail.com
This appears to be fixed in 0.09.