-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Fabrizio Mazzoni asked: >>> How can i find out if a prepared statement already exists..? Is >>> there a function or a query i can execute ..?? Greg replied: >> I have not seen an answer to this, and I am curious as well. Anyone? Alvaro Herrera suggested: > Trying to prepare a dummy query maybe. Sure, but this creates additional traffic, and causes a transaction to fail, so it's not really feasible if you are within one. I checked the pgsql source, and there is no public interface to determine if a named statement already exists. I do not know why the original poster needed to know, but I've solved it within DBD::Pg by simply using the fact that statement names are not shared across connections and having each connection (that is, ecah database handle) store an integer starting at 1. Generated statements are simply named "dbdpg_1", "dbdpg_2", etc. and the increment is increased only after a statement is created successfully. There is also support for user-created (and user-named) statements, with the caveat that it is up to the user, not DBD::Pg, to watch for name collisions. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200406061855 -----BEGIN PGP SIGNATURE----- iD8DBQFAw6G9vJuQZxSWSsgRAkOPAJ9ioEBN2dhUFNdsKzACdLCzEmmrYwCfZY4P 5qkzlSPmdFwmU3vG14pDSmA= =hEeT -----END PGP SIGNATURE-----
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org