Skip Menu |

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

Report information
The Basics
Id: 99144
Status: resolved
Priority: 0/
Queue: DBD-Pg
People
Owner: greg [...] turnstep.com
Requestors: vaclav.ovsik [...] i.cz
Cc:
AdminCc:
Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: 3.4.2

History Show all quoted text
  Thu Sep 25 15:30:13 2014 vaclav.ovsik [...] i.cz - Ticket created
Subject: DBD::Pg 3.4.1 - dbh method table_info() fails with postgresql 9.1
Date: Thu, 25 Sep 2014 21:30:00 +0200
To: bug-DBD-Pg [...] rt.cpan.org
From: Václav Ovsík <vaclav.ovsik [...] i.cz>
Hi, thanks for DBD::Pg beforehand! My last upgrade of DBD::Pg to version 3.4.1 on Debian (I did the rebuild from unstable Debian Sid for stable Debian Wheezy) brought some problem with Request Tracker. I'm preparing upgrade from 3.8.16 do 4.2.7 of Request Tracker and upgrade process failed. I analyzed down to the following: zito@rt2:~$ cat pgtableinfo2 #!/usr/bin/perl use DBI; $dbh = DBI->connect("dbi:Pg:dbname=zito", '', '', {AutoCommit => 1}); my $sth = $dbh->table_info( '', '', '', "'TABLE'"); zito@rt2:~$ ./pgtableinfo2 DBD::Pg::db table_info failed: ERROR: operator does not exist: text = integer LINE 34: ) ti WHERE "TABLE_TYPE" IN (1) ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. at ./pgtableinfo2 line 4. Previous version of DBD::Pg (2.19.3) was not affected. Cheers -- Zito
  Thu Sep 25 16:54:43 2014 greg [...] turnstep.com - Correspondence added
Thanks for the report, we will look into this soon.
  Thu Sep 25 16:54:43 2014 The RT System itself - Status changed from 'new' to 'open'
  Thu Sep 25 16:54:44 2014 greg [...] turnstep.com - Taken
  Thu Sep 25 17:06:35 2014 greg [...] turnstep.com - Correspondence added
Fixed in 9f3cce7ac9574f6329856fdc1f11bd73fe6a572b, will be a part of the upcoming release, most likely 3.4.2
  Thu Sep 25 17:06:36 2014 greg [...] turnstep.com - Status changed from 'open' to 'patched'
  Thu Sep 25 18:42:47 2014 greg [...] turnstep.com - Correspondence added
Version 3.4.2 is out: please test it out when you can. Note that you don't need to single quote TABLE, you can simply do: , 'TABLE') or , "TABLE")
  Fri Sep 26 09:13:30 2014 vaclav.ovsik [...] i.cz - Correspondence added
Subject: Re: [rt.cpan.org #99144] DBD::Pg 3.4.1 - dbh method table_info() fails with postgresql 9.1
Date: Fri, 26 Sep 2014 15:13:12 +0200
To: Greg Sabino Mullane via RT <bug-DBD-Pg [...] rt.cpan.org>
From: Václav Ovsík <vaclav.ovsik [...] i.cz>
Thank you very much for the fastest bug fix I ever see! ;) I build the Debian package libdbd-pg-perl_3.4.2-1~icz7+1_amd64.deb and rerun database upgrade of our Request Tracker and it reached the end with success. The problem with 3.4.1 version was in https://github.com/bestpractical/rt/blob/4.2-trunk/etc/upgrade/3.9.8/content where the method $RT::Handle->_TableNames is called The method is define in https://github.com/bestpractical/rt/blob/4.2-trunk/lib/RT/Handle.pm and it contains: $dbh->table_info( '', undef, undef, "'TABLE'"); The bug is fixed and this ticket can be closed. Thank you very much Cheers -- Zito
  Mon Oct 06 07:53:09 2014 greg [...] turnstep.com - Status changed from 'patched' to 'resolved'
  Mon Oct 06 07:53:09 2014 greg [...] turnstep.com - Fixed in 3.4.2 added