User-Agent: Microsoft-Entourage/10.1.4.030702.0
Date: Wed, 14 Sep 2005 06:50:44 -0400
Subject: Re: Beta of DBD::Pg 1.44 available
From: Sean Davis <sdavis2@mail.nih.gov>
To: Greg Sabino Mullane <greg@turnstep.com>, <pgsql-interfaces@postgresql.org>
Message-ID: <BF4D78C4.E891%sdavis2@mail.nih.gov>
In-Reply-To: <3018ff362cbf96cac90844ff9641bc10@biglumber.com>
Mime-version: 1.0
Content-type: text/plain; charset="US-ASCII"
Content-transfer-encoding: 7bit


On 9/13/05 8:24 PM, "Greg Sabino Mullane" <greg@turnstep.com> wrote:

> 
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> 
> 
> The first beta of DBD::Pg version 1.44 is now available at:
> 
> http://search.cpan.org/~dbdpg/
> 
> SHA1 and MD5 Checksums for the tarball:
> 
> 1c8593d2bf66562ac9ff1f169bb02aabb178ad00  DBD-Pg-1.43_1.tar.gz
> a5752ac6d69928f7a8b2254ae8377ee0  DBD-Pg-1.43_1.tar.gz
> 
> This version has some deep changes, so testing is much appreciated. In
> particular, both the do() and quote() methods have been rewritten.
> In addition, the get_info() information has been greatly expanded.
> Information I was not sure about is marked with a "## ??" in the Pg.pm
> code - anyone familiar with the ODBC / ANSI standards, please take a look.
> 
> Here is the complete list of changes:
> 
> - Added $dbh->{pg_default_port} method [GSM]
> - Overhaul get_info data, add many more values [GSM]
> - Overhaul type_info data (fixes CPAN bug #13806) [GSM]
> - Explicitly prevent any parsing of statements for placeholders
>  unless they begin with "SELECT", "INSERT", "UPDATE", or "DELETE"
>  Suggested by (and fixes) CPAN bug #13608 [GSM]

Greg,

Thanks for doing all of this.  I will give it a whirl.  Just a quick
question on the point directly above: does this imply that explain and
explain analyze are excluded from placeholder parsing?  I don't personally
use them programmatically, but I think that particularly for count(*) types
of queries or receiving estimates of the number of returned tuples without
executing the query, people could potentially use explain select....  Pardon
my laziness for not looking at the code for my own answers.

Thanks,
Sean