Re: global variable problem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



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/



[Index of Archives]     [Postgresql General]     [Postgresql Admin]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Backpacking]     [Postgresql Jobs]

  Powered by Linux