On Fri, Jun 16, 2006 at 08:55:16AM -0400, Rod Taylor wrote: > BEGIN; > SAVEPOINT; > SELECT * FROM temporary_prepared_statement; > ROLLBACK TO SAVEPOINT < on failure>; > CREATE TEMPORARY TABLE temporary_prepared_statement ...; > COMMIT; > > Now you have a place to store and retrieve prepared connection state for > the lifetime of the database backend provided PHP doesn't remove > temporary tables on the connection.
This doesn't help today, but 8.2 will have a pg_prepared_statements view. http://archives.postgresql.org/pgsql-committers/2006-01/msg00143.php http://developer.postgresql.org/docs/postgres/view-pg-prepared-statements.html test=> PREPARE stmt (integer) AS SELECT * FROM foo WHERE x = $1; test=> \x Expanded display is on. test=> SELECT * FROM pg_prepared_statements; -[ RECORD 1 ]---+---------------------------------------------------------- name | stmt statement | PREPARE stmt (integer) AS SELECT * FROM foo WHERE x = $1; prepare_time | 2006-06-16 07:07:41.682999-06 parameter_types | {integer} from_sql | t -- Michael Fuhr ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
