Postgres autocommit?

kenny_dilger

Hello,

I am running PHP 4.3.1 and postgres 7.4. When I issue SET AUTOCOMMIT TO FALSE I get an error saying its no longer supported.

Does someone know of an alternative way to turn off autocommit?

Thanks,
Kenny

chriskl

It's been removed as a SET option in 7.4. It's now part of the binary connection protocol. I'm not sure that PHP has added support for most of 7.4's new binary protocol yet. It's pretty lame.

kenny_dilger

Well that is a huge bummer... If anyone knows a work around then please let me know asap. Been moving off of our oracle system as the cost just is not justified, but I need basic functionality still!!!

Sxooter

Just issue a pg_query("begin");

at the beginning of your page and a

pg_query("commit"):

at the end.

If there are any errors, the commit will error out.

Also, the latest version of PHP is 4.3.6, and while I'm not sure it fixes this issue or not, it might be worth trying it out.

Also, PHP 5 may have this in it. But I've not even touched that. It's up to RC status, so it should be usable for testing / development.

kenny_dilger

Thought about doing that. It may work out still. In this particular case its more of an error handling issue then needing to issue commands in batch.

I have data going to two different systems (as400 and postgres in this case). If entry errors out on any of the calls I am needing to rollback all records for a given transaction...

But I guess at the top of every page the BEGIN could be issued... Then when an error is encountered just issue pg_query('rollback'); ...

Thanks for the tips,
Kenny