From dev-return-15936-apmail-apr-dev-archive=apr.apache.org@apr.apache.org Fri Apr 07 22:50:19 2006 Return-Path: Delivered-To: apmail-apr-dev-archive@www.apache.org Received: (qmail 39121 invoked from network); 7 Apr 2006 22:50:19 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 7 Apr 2006 22:50:19 -0000 Received: (qmail 68727 invoked by uid 500); 7 Apr 2006 22:50:18 -0000 Delivered-To: apmail-apr-dev-archive@apr.apache.org Received: (qmail 68389 invoked by uid 500); 7 Apr 2006 22:50:17 -0000 Mailing-List: contact dev-help@apr.apache.org; run by ezmlm Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Id: Delivered-To: mailing list dev@apr.apache.org Received: (qmail 68378 invoked by uid 99); 7 Apr 2006 22:50:17 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 07 Apr 2006 15:50:17 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: neutral (asf.osuosl.org: local policy) Received: from [80.229.52.226] (HELO asgard.webthing.com) (80.229.52.226) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 07 Apr 2006 15:50:16 -0700 Received: from asgard (asgard [192.168.10.2]) by asgard.webthing.com (Postfix) with ESMTP id 185E964561 for ; Fri, 7 Apr 2006 23:49:55 +0100 (BST) From: Nick Kew Organization: WebThing Ltd To: dev@apr.apache.org Subject: Re: DBD: Prepared statements with PGSQL Date: Fri, 7 Apr 2006 23:49:51 +0100 User-Agent: KMail/1.8.3 References: <20060406124316.3bwyt9ekg0s48488@www.rexursive.com> <20060407101704.uf3sjnqncos0gwk0@www.rexursive.com> <7edfeeef0604071145y18d90abbt9a7478a33a4bad58@mail.gmail.com> In-Reply-To: <7edfeeef0604071145y18d90abbt9a7478a33a4bad58@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200604072349.54047.nick@webthing.com> X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N On Friday 07 April 2006 19:45, Garrett Rooney wrote: > On 4/6/06, Bojan Smojver wrote: > > Quoting Bojan Smojver : > > > Is there are particular reason why PQprepare() isn't used to prepare > > > statements? Currently, DBD code builds an SQL statement with PREPARE > > > [...] at the beginning and then executes that, instead of calling the > > > mentioned API function. > > > > Don't worry about answering this. Looks like 7.4 doesn't have this > > call, so I'm guessing it a backward compatibility thing. > > Well, there's no reason we can't use it if it is available in the > version of the postgres libraries we link against. Shouldn't be too > hard to put the autoconf glue together to detect it. Indeedie. I'm not sure why it's not there. But much of the code there is grabbed from stuff that's older than apr_dbd. It may not have existed in the PgSQL version originally used. It's also possible that it did exist but that the code was written with insufficient reference to TFM. Do you know when PQprepare first appeared? -- Nick Kew