Skip Menu |
 
rt.cpan.org will be shut down on March 1st, 2021.

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



MIME-Version: 1.0
X-Spam-Status: No, score=-2.664 tagged_above=-99.9 required=10 tests=[AWL=-0.096, BAYES_00=-1.9, RP_MATCHES_RCVD=-0.668] autolearn=ham
Content-Disposition: inline
X-Spam-Flag: NO
content-type: text/plain; charset="utf-8"
Message-ID: <20140925192959.GC5868 [...] bobek.localdomain>
X-Virus-Scanned: Debian amavisd-new at bestpractical.com
X-Virus-Scanned: Debian amavisd-new at ns1.i.cz
X-Spam-Score: -2.664
Received: from localhost (localhost [127.0.0.1]) by hipster.bestpractical.com (Postfix) with ESMTP id 0CE1F240568 for <cpan-bug+DBD-Pg [...] hipster.bestpractical.com>; Thu, 25 Sep 2014 15:30:12 -0400 (EDT)
Received: from hipster.bestpractical.com ([127.0.0.1]) by localhost (hipster.bestpractical.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id V-FUdhVxSjW4 for <cpan-bug+DBD-Pg [...] hipster.bestpractical.com>; Thu, 25 Sep 2014 15:30:10 -0400 (EDT)
Received: from la.mx.develooper.com (x1.develooper.com [207.171.7.70]) by hipster.bestpractical.com (Postfix) with SMTP id 8CF4324046B for <bug-DBD-Pg [...] rt.cpan.org>; Thu, 25 Sep 2014 15:30:10 -0400 (EDT)
Received: (qmail 14808 invoked by alias); 25 Sep 2014 19:30:10 -0000
Received: from vidle.i.cz (HELO vidle.i.cz) (78.31.27.2) by la.mx.develooper.com (qpsmtpd/0.28) with ESMTP; Thu, 25 Sep 2014 12:30:05 -0700
Received: from ns1.i.cz (unknown [192.168.24.101]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client CN "smtp.i.cz", Issuer "ICZ a.s. Issuing CA" (verified OK)) by vidle.i.cz (Postfix) with ESMTPS id 0F33AAD04D for <bug-DBD-Pg [...] rt.cpan.org>; Thu, 25 Sep 2014 21:29:59 +0200 (CEST)
Received: from localhost (localhost [127.0.0.1]) by ns1.i.cz (Postfix) with ESMTP id 8D3CE26 for <bug-DBD-Pg [...] rt.cpan.org>; Thu, 25 Sep 2014 21:30:00 +0200 (CEST)
Received: from ns1.i.cz ([127.0.0.1]) by localhost (ns1.i.cz [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id YFV39TOybQ63 for <bug-DBD-Pg [...] rt.cpan.org>; Thu, 25 Sep 2014 21:30:00 +0200 (CEST)
Received: from [127.0.0.1] (localhost [127.0.0.1]) by Authenticated User (ns1.i.cz) with ESMTPSA id 6DBB425
Received: by bobek.localdomain (Postfix, from userid 1000) id 0B89E1605A6; Thu, 25 Sep 2014 21:30:00 +0200 (CEST)
Delivered-To: cpan-bug+DBD-Pg [...] hipster.bestpractical.com
User-Agent: Mutt/1.5.23 (2014-03-12)
Subject: DBD::Pg 3.4.1 - dbh method table_info() fails with postgresql 9.1
Return-Path: <vaclav.ovsik [...] i.cz>
X-RT-Mail-Extension: dbd-pg
X-Original-To: cpan-bug+DBD-Pg [...] hipster.bestpractical.com
X-Spam-Check-BY: la.mx.develooper.com
Date: Thu, 25 Sep 2014 21:30:00 +0200
X-Spam-Level:
To: bug-DBD-Pg [...] rt.cpan.org
From: Václav Ovsík <vaclav.ovsik [...] i.cz>
X-RT-Original-Encoding: ascii
X-RT-Interface: Email
Content-Length: 925
Download (untitled) / with headers
text/plain 925b
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
MIME-Version: 1.0
In-Reply-To: <20140925192959.GC5868 [...] bobek.localdomain>
X-Mailer: MIME-tools 5.504 (Entity 5.504)
Content-Disposition: inline
X-RT-Interface: Web
References: <20140925192959.GC5868 [...] bobek.localdomain>
Content-Type: text/plain; charset="utf-8"
Message-ID: <rt-4.0.18-10568-1411678483-406.99144-0-0 [...] rt.cpan.org>
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
X-RT-Encrypt: 0
X-RT-Sign: 0
Content-Length: 51
Thanks for the report, we will look into this soon.
MIME-Version: 1.0
In-Reply-To: <rt-4.0.18-10568-1411678483-406.99144-0-0 [...] rt.cpan.org>
X-Mailer: MIME-tools 5.504 (Entity 5.504)
Content-Disposition: inline
X-RT-Interface: Web
References: <20140925192959.GC5868 [...] bobek.localdomain> <rt-4.0.18-10568-1411678483-406.99144-0-0 [...] rt.cpan.org>
Content-Type: text/plain; charset="utf-8"
Message-ID: <rt-4.0.18-10568-1411679195-683.99144-0-0 [...] rt.cpan.org>
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
X-RT-Encrypt: 0
X-RT-Sign: 0
Content-Length: 110
Download (untitled) / with headers
text/plain 110b
Fixed in 9f3cce7ac9574f6329856fdc1f11bd73fe6a572b, will be a part of the upcoming release, most likely 3.4.2
MIME-Version: 1.0
In-Reply-To: <rt-4.0.18-10568-1411679195-683.99144-0-0 [...] rt.cpan.org>
X-Mailer: MIME-tools 5.504 (Entity 5.504)
Content-Disposition: inline
X-RT-Interface: Web
References: <20140925192959.GC5868 [...] bobek.localdomain> <rt-4.0.18-10568-1411678483-406.99144-0-0 [...] rt.cpan.org> <rt-4.0.18-10568-1411679195-683.99144-0-0 [...] rt.cpan.org>
Content-Type: text/plain; charset="utf-8"
Message-ID: <rt-4.0.18-5581-1411684967-1374.99144-0-0 [...] rt.cpan.org>
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
X-RT-Encrypt: 0
X-RT-Sign: 0
Content-Length: 152
Download (untitled) / with headers
text/plain 152b
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")
MIME-Version: 1.0
X-Spam-Status: No, score=-4.657 tagged_above=-99.9 required=10 tests=[AWL=1.911, BAYES_00=-1.9, FROM_OUR_RT=-4, RP_MATCHES_RCVD=-0.668] autolearn=ham
In-Reply-To: <rt-4.0.18-5581-1411684967-1645.99144-6-0 [...] rt.cpan.org>
Content-Disposition: inline
X-Spam-Flag: NO
X-RT-Interface: API
References: <RT-Ticket-99144 [...] rt.cpan.org> <20140925192959.GC5868 [...] bobek.localdomain> <rt-4.0.18-10568-1411678483-406.99144-6-0 [...] rt.cpan.org> <rt-4.0.18-10568-1411679195-683.99144-6-0 [...] rt.cpan.org> <rt-4.0.18-5581-1411684967-1645.99144-6-0 [...] rt.cpan.org>
X-Virus-Scanned: Debian amavisd-new at bestpractical.com
X-Virus-Scanned: Debian amavisd-new at ns1.i.cz
Message-ID: <20140926131312.GE11124 [...] bobek.localdomain>
content-type: text/plain; charset="utf-8"
X-RT-Original-Encoding: utf-8
X-Spam-Score: -4.657
Received: from localhost (localhost [127.0.0.1]) by hipster.bestpractical.com (Postfix) with ESMTP id 2D6F224046B for <cpan-bug+DBD-Pg [...] hipster.bestpractical.com>; Fri, 26 Sep 2014 09:13:29 -0400 (EDT)
Received: from hipster.bestpractical.com ([127.0.0.1]) by localhost (hipster.bestpractical.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id HqFbrpTkyYB4 for <cpan-bug+DBD-Pg [...] hipster.bestpractical.com>; Fri, 26 Sep 2014 09:13:27 -0400 (EDT)
Received: from la.mx.develooper.com (x1.develooper.com [207.171.7.70]) by hipster.bestpractical.com (Postfix) with SMTP id 8C1482403FB for <bug-DBD-Pg [...] rt.cpan.org>; Fri, 26 Sep 2014 09:13:27 -0400 (EDT)
Received: (qmail 2260 invoked by alias); 26 Sep 2014 13:13:26 -0000
Received: from vidle.i.cz (HELO vidle.i.cz) (78.31.27.2) by la.mx.develooper.com (qpsmtpd/0.28) with ESMTP; Fri, 26 Sep 2014 06:13:19 -0700
Received: from ns1.i.cz (unknown [192.168.24.101]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client CN "smtp.i.cz", Issuer "ICZ a.s. Issuing CA" (verified OK)) by vidle.i.cz (Postfix) with ESMTPS id B39BBAD053 for <bug-DBD-Pg [...] rt.cpan.org>; Fri, 26 Sep 2014 15:13:12 +0200 (CEST)
Received: from localhost (localhost [127.0.0.1]) by ns1.i.cz (Postfix) with ESMTP id 3639425 for <bug-DBD-Pg [...] rt.cpan.org>; Fri, 26 Sep 2014 15:13:14 +0200 (CEST)
Received: from ns1.i.cz ([127.0.0.1]) by localhost (ns1.i.cz [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id lr24_SR_5qJk for <bug-DBD-Pg [...] rt.cpan.org>; Fri, 26 Sep 2014 15:13:14 +0200 (CEST)
Received: from bobek.localdomain (bobek.plz.i.cz [192.168.64.71]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client CN "Ovs??k V??clav (zito)", Issuer "ICZ Issuing CA" (not verified)) by ns1.i.cz (Postfix) with ESMTPS id A995724 for <bug-DBD-Pg [...] rt.cpan.org>; Fri, 26 Sep 2014 15:13:13 +0200 (CEST)
Received: by bobek.localdomain (Postfix, from userid 1000) id 2639C1603F8; Fri, 26 Sep 2014 15:13:12 +0200 (CEST)
Delivered-To: cpan-bug+DBD-Pg [...] hipster.bestpractical.com
Subject: Re: [rt.cpan.org #99144] DBD::Pg 3.4.1 - dbh method table_info() fails with postgresql 9.1
User-Agent: Mutt/1.5.23 (2014-03-12)
Return-Path: <vaclav.ovsik [...] i.cz>
X-Spam-Check-BY: la.mx.develooper.com
X-Original-To: cpan-bug+DBD-Pg [...] hipster.bestpractical.com
X-RT-Mail-Extension: dbd-pg
Date: Fri, 26 Sep 2014 15:13:12 +0200
X-Spam-Level:
To: Greg Sabino Mullane via RT <bug-DBD-Pg [...] rt.cpan.org>
From: Václav Ovsík <vaclav.ovsik [...] i.cz>
RT-Message-ID: <rt-4.0.18-19774-1411737210-926.99144-0-0 [...] rt.cpan.org>
Content-Length: 628
Download (untitled) / with headers
text/plain 628b
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


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.