prepared queries

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: prepared queries
Date: 2004-02-05 15:40:31
Message-ID: 402263EF.5020300@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


The current release of DBD::Pg contains this in the CHANGES file:

- $dbh->prepare() rewrites the SQL statement into an internal form,
striping out comments and whitespace, and if PostgreSQL
> 7.3 takes the
stripped statement and passes that to Postgres' PREPARE
statement,
then rewrites the statement as 'EXECUTE
"DBD::PG::cached_query n"
($1, $2, ... $n, $n+1)' for DBD::Pg's execute.
-- Currently disabled until PREPARE works a little better

Is there a TODO here, or is it just that the Driver is a bit out of date?

Perhaps one of these items relates to the matter?:

. Allow clients to query a list of WITH HOLD cursors and prepared statements
. Allow libpq to return information about prepared queries

It's a pity if such an important client as DBD:Pg can't really use PQs.
Is the problem that you need to supply the data types of the params at
PREPARE time rather than discovering them from the result of a PREPARE?

cheers

andrew

Browse pgsql-hackers by date

  From Date Subject
Next Message Jon Jensen 2004-02-05 15:50:20 Re: dollar quoting
Previous Message Shridhar Daithankar 2004-02-05 15:15:48 Re: [pgsql-hackers-win32] Sync vs. fsync during checkpoint