Hi,
>| > doing a roolback in this connection, doest it will roolback all scripts?
>
>No, at the end of the script PHP sends a ROLLBACK automatically to
>postgres. So it can rollback the queries in the actual request (page) only.
I hope not!
If you begin a transaction in your PHP code explicitly, then it's the same
as manually running the commands from the psql monitor, so you need to
explicitly say "COMMIT" or "ROLLBACK".
Remember that postgres automatically wraps everything in transactions, so
unless you explicitly start one, you can't do a rollback from a previous
update / insert query (because this is a different transaction).
-----------------
Chris Smith
http://www.squiz.net/