| 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: | |
| Content-Length: | 925 |
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