Skip Menu |

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

Report information
The Basics
Id: 81087
Status: resolved
Priority: 0/
Queue: DBD-Pg
People
Owner: Nobody in particular
Requestors: cpan [...] arwin.net
Cc:
AdminCc:
Bug Information
Severity: Important
Broken in: 2.19.3
Fixed in: (no value)

History Show all quoted text
  Fri Nov 09 17:38:42 2012 cpan [...] arwin.net - Ticket created
Subject: Adjustments to table_info() for the loss of spclocation in 9.2
Postgres 9.2 removed spclocation from pg_tablespace. Instead, pg_tablespace_location(oid) can be used. See section E.2.2.1 of the release notes for 9.2 http://www.postgresql.org/docs/devel/static/release-9-2.html This affects the table_info function of DBD::Pg and causes it to die a horrible death. E.g. "DBD::Pg::db table_info failed: ERROR: column t.spclocation does not exist" Someone has posted a patch that appears to address the issue but the latest release (DBD::Pg 2.19.3) doesn't include the new code: http://www.nntp.perl.org/group/perl.dbd.pg.changes/2012/05/msg1080.html Thanks, -Ben Arwin
  Fri Nov 09 17:53:26 2012 greg [...] turnstep.com - Correspondence added
Show quoted text
> latest release (DBD::Pg > 2.19.3) doesn't include the new code: > http://www.nntp.perl.org/group/perl.dbd.pg.changes/2012/05/msg1080.html
Are you sure you are looking at the right file/version? That code is indeed in there, see: http://cpansearch.perl.org/src/TURNSTEP/DBD-Pg-2.19.3/Pg.pm
  Fri Nov 09 17:53:28 2012 The RT System itself - Status changed from 'new' to 'open'
  Fri Nov 09 18:25:18 2012 cpan [...] arwin.net - Correspondence added
From: cpan [...] arwin.net
Show quoted text
> > Are you sure you are looking at the right file/version? That code is > indeed in there, see: > > http://cpansearch.perl.org/src/TURNSTEP/DBD-Pg-2.19.3/Pg.pm
Well, that's embarrassing. Not sure what I was looking at before. Please ignore me. Thanks for the quick response in any case! -Ben
  Fri Nov 09 19:00:02 2012 greg [...] turnstep.com - Correspondence added
Show quoted text
> Not sure what I was looking at before.
No worries. Thanks for the report. Better the occasional false positive to indicate people are using and care about the module! :) I also added a specific entry to the Changes file.
  Fri Nov 09 19:00:03 2012 greg [...] turnstep.com - Status changed from 'open' to 'resolved'