prepared queries

Started by Andrew Dunstanalmost 22 years ago1 messages
#1Andrew Dunstan
andrew@dunslane.net

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