Skip Menu |
 

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

Report information
The Basics
Id: 88439
Status: rejected
Priority: 0/
Queue: DBD-Pg

People
Owner: greg [...] turnstep.com
Requestors: joost [...] quarantainenet.nl
Cc:
AdminCc:

Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)



From joost [...] quarantainenet.nl Thu Sep 5 10: 03:02 2013
MIME-Version: 1.0
X-Spam-Status: No, score=-6.9 tagged_above=-99.9 required=10 tests=[BAYES_00=-1.9, RCVD_IN_DNSWL_HI=-5] autolearn=ham
X-Spam-Flag: NO
content-type: text/plain; charset="utf-8"
Message-ID: <52288EFF.4030305 [...] quarantainenet.nl>
X-Virus-Scanned: Debian amavisd-new at bestpractical.com
X-Spam-Score: -6.9
Received: from localhost (localhost [127.0.0.1]) by hipster.bestpractical.com (Postfix) with ESMTP id 04A65241223 for <cpan-bug+DBD-Pg [...] hipster.bestpractical.com>; Thu, 5 Sep 2013 10:03:02 -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 J1nDFaFbeHYz for <cpan-bug+DBD-Pg [...] hipster.bestpractical.com>; Thu, 5 Sep 2013 10:02:56 -0400 (EDT)
Received: from la.mx.develooper.com (x1.develooper.com [207.171.7.70]) by hipster.bestpractical.com (Postfix) with SMTP id 65D8E241210 for <bug-DBD-Pg [...] rt.cpan.org>; Thu, 5 Sep 2013 10:02:56 -0400 (EDT)
Received: (qmail 1341 invoked by alias); 5 Sep 2013 14:02:55 -0000
Received: from mail.quarantainenet.nl (HELO mail.quarantainenet.nl) (91.220.21.66) by la.mx.develooper.com (qpsmtpd/0.28) with ESMTP; Thu, 05 Sep 2013 07:02:46 -0700
Received: from rev-9.21.220.91.quarantainenet.nl ([91.220.21.9] helo=[10.100.3.51]) by mail.quarantainenet.nl with esmtpsa (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:32) (Exim 4.69) (envelope-from <joost [...] quarantainenet.nl>) id 1VHa8v-0001Bj-G5 for bug-DBD-Pg [...] rt.cpan.org; Thu, 05 Sep 2013 16:02:41 +0200
Delivered-To: cpan-bug+DBD-Pg [...] hipster.bestpractical.com
Subject: Incompatibility between postgres 9.2 and DBD:Pg (table_info and primary_key_info)
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:17.0) Gecko/20130801 Thunderbird/17.0.8
Return-Path: <joost [...] quarantainenet.nl>
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, 05 Sep 2013 16:02:39 +0200
X-Spam-Level:
To: bug-DBD-Pg [...] rt.cpan.org
Content-Transfer-Encoding: 7bit
X-Enigmail-Version: 1.5.2
From: Casper Joost Eyckelhof <joost [...] quarantainenet.nl>
X-RT-Original-Encoding: iso-8859-1
X-RT-Interface: Email
Content-Length: 1314
Download (untitled) / with headers
text/plain 1.2k
Summary: DBD::Pg generates queries that reference a no longer existing field (in postgres 9.2) Seen on DBD::Pg versions packaged with Debian Squeeze and Debian Wheezy, but "incompatible code" is still there in latest DBD:Pg (DBD-Pg-2.19.3). Error: DBD::Pg::db table_info failed: ERROR: column t.spclocation does not exist LINE 11: ...t(t.spcname) AS "pg_tablespace_name", quote_ident(t.spclocat... Changelog from postgres 9.2 states: ( http://www.postgresql.org/docs/9.2/interactive/release-9-2.html ) "E.5.2.1. System Catalogs Remove the spclocation field from pg_tablespace (Magnus Hagander) This field was duplicative of the symbolic links that actually define tablespace locations, and thus risked errors of omission when moving a tablespace. This change allows tablespace directories to be moved while the server is down, by manually adjusting the symbolic links. To replace this field, we have added pg_tablespace_location() to allow querying of the symbolic links." Quick fix for postgres 9.2 is replacing "quote_ident(t.spclocation)" by "quote_ident(pg_tablespace_location(t.oid))" at least twice in DBD::Pg, in the functions table_info and primary_key_info. But this will probably break things for postgres <= 9.1. -- Regards, Casper Joost Eyckelhof Quarantainenet BV The Netherlands
MIME-Version: 1.0
In-Reply-To: <52288EFF.4030305 [...] quarantainenet.nl>
X-Mailer: MIME-tools 5.504 (Entity 5.504)
Content-Disposition: inline
X-RT-Interface: Web
References: <52288EFF.4030305 [...] quarantainenet.nl>
Content-Type: text/plain; charset="utf-8"
Message-ID: <rt-4.0.16-28844-1378391765-1458.88439-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: 443
Download (untitled) / with headers
text/plain 443b
That is unusual - can you doublecheck the version? DBD::Pg 2.19.3 definitely has solved this problem. See ticket 77042. It could be some other strange interaction such as a failure to detect the correct Postgres backend version number and thus generating the wrong SQL. Does your Pg.pm contain these lines?: if ($dbh->{private_dbdpg}{version} >= 90200) { $pri_key_sql =~ s/t.spclocation/pg_tablespace_location(t.oid)/; }
From joost [...] quarantainenet.nl Fri Sep 6 02: 35:55 2013
MIME-Version: 1.0
X-Spam-Status: No, score=-6.9 tagged_above=-99.9 required=10 tests=[BAYES_00=-1.9, RCVD_IN_DNSWL_HI=-5] autolearn=ham
In-Reply-To: <rt-4.0.16-28844-1378391765-733.88439-6-0 [...] rt.cpan.org>
X-Spam-Flag: NO
X-RT-Interface: API
References: <RT-Ticket-88439 [...] rt.cpan.org> <52288EFF.4030305 [...] quarantainenet.nl> <rt-4.0.16-28844-1378391765-733.88439-6-0 [...] rt.cpan.org>
X-Virus-Scanned: Debian amavisd-new at bestpractical.com
Message-ID: <522977BC.2050008 [...] quarantainenet.nl>
content-type: text/plain; charset="utf-8"
X-RT-Original-Encoding: utf-8
X-Spam-Score: -6.9
Received: from localhost (localhost [127.0.0.1]) by hipster.bestpractical.com (Postfix) with ESMTP id C0A3924063B for <cpan-bug+DBD-Pg [...] hipster.bestpractical.com>; Fri, 6 Sep 2013 02:35:55 -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 ED1lY9IMz+t8 for <cpan-bug+DBD-Pg [...] hipster.bestpractical.com>; Fri, 6 Sep 2013 02:35:54 -0400 (EDT)
Received: from la.mx.develooper.com (x1.develooper.com [207.171.7.70]) by hipster.bestpractical.com (Postfix) with SMTP id 35F67240559 for <bug-DBD-Pg [...] rt.cpan.org>; Fri, 6 Sep 2013 02:35:53 -0400 (EDT)
Received: (qmail 12421 invoked by alias); 6 Sep 2013 06:35:53 -0000
Received: from mail.quarantainenet.nl (HELO mail.quarantainenet.nl) (91.220.21.66) by la.mx.develooper.com (qpsmtpd/0.28) with ESMTP; Thu, 05 Sep 2013 23:35:47 -0700
Received: from rev-9.21.220.91.quarantainenet.nl ([91.220.21.9] helo=[10.100.3.51]) by mail.quarantainenet.nl with esmtpsa (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:32) (Exim 4.69) (envelope-from <joost [...] quarantainenet.nl>) id 1VHpdu-00080v-7W for bug-DBD-Pg [...] rt.cpan.org; Fri, 06 Sep 2013 08:35:42 +0200
Delivered-To: cpan-bug+DBD-Pg [...] hipster.bestpractical.com
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:17.0) Gecko/20130801 Thunderbird/17.0.8
Subject: Re: [rt.cpan.org #88439] Incompatibility between postgres 9.2 and DBD:Pg (table_info and primary_key_info)
Return-Path: <joost [...] quarantainenet.nl>
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, 06 Sep 2013 08:35:40 +0200
X-Spam-Level:
To: bug-DBD-Pg [...] rt.cpan.org
X-Enigmail-Version: 1.5.2
Content-Transfer-Encoding: 7bit
From: Casper Joost Eyckelhof <joost [...] quarantainenet.nl>
RT-Message-ID: <rt-4.0.16-6955-1378449356-681.88439-0-0 [...] rt.cpan.org>
Content-Length: 1058
Hi, I just downloaded the newest sources from CPAN again, and the special case for ">= 90200" is there. I assume that it was there the first time too and I somehow missed it, or downloaded another version by mistake :) The fix does seem to be missing in Debian Wheezy though (2.19.2-2), but that is something I have to report to the Debian team. Thanks for the quick response and sorry for the misleading report. On 5-9-2013 16:36, Greg Sabino Mullane via RT wrote: Show quoted text
> <URL: https://rt.cpan.org/Ticket/Display.html?id=88439 > > > That is unusual - can you doublecheck the version? DBD::Pg 2.19.3 definitely has solved this problem. See ticket 77042. It could be some other strange interaction such as a failure to detect the correct Postgres backend version number and thus generating the wrong SQL. Does your Pg.pm contain these lines?: > > if ($dbh->{private_dbdpg}{version} >= 90200) { > $pri_key_sql =~ s/t.spclocation/pg_tablespace_location(t.oid)/; > }
-- Met vriendelijke groet, Casper Joost Eyckelhof Quarantainenet BV
MIME-Version: 1.0
In-Reply-To: <rt-4.0.16-6955-1378449356-681.88439-0-0 [...] rt.cpan.org>
X-Mailer: MIME-tools 5.504 (Entity 5.504)
Content-Disposition: inline
X-RT-Interface: Web
References: <RT-Ticket-88439 [...] rt.cpan.org> <52288EFF.4030305 [...] quarantainenet.nl> <rt-4.0.16-28844-1378391765-733.88439-6-0 [...] rt.cpan.org> <522977BC.2050008 [...] quarantainenet.nl> <rt-4.0.16-6955-1378449356-681.88439-0-0 [...] rt.cpan.org>
Content-Type: text/plain; charset="utf-8"
Message-ID: <rt-4.0.16-12066-1378869511-435.88439-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: 236
Download (untitled) / with headers
text/plain 236b
Show quoted text
> Thanks for the quick response and sorry for the misleading report.
Thank you for taking the time to report it. We strive to keep upstream and downstram in sync as much as possible, so please keep us posted about any Debian findings.


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.