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
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
