prepared queries
От | Andrew Dunstan |
---|---|
Тема | prepared queries |
Дата | |
Msg-id | 402263EF.5020300@dunslane.net обсуждение исходный текст |
Список | 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 disableduntil 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
В списке pgsql-hackers по дате отправления: