Postgres auto-commit
| From: | Skippy | Date: | Tue, 04 Oct 2005 11:08:56 +0000 |
| Subject: | Postgres auto-commit | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-223598@lists.php.net to get a copy of this message | ||
How can I disable auto-commit for a Postgres connection? Apparently
server-side autocommit was thrown out in Postgres 8.0, and clients have to
issue their own setting (which is sensible).
The default is on (which I don't want). psql is apparently able to set or
unset the AUTOCOMMIT option, but I found nothing similar for PHP.
There is no ini setting for it. There is no function for it. Perhaps the
"options" part of the connection string passed to pg_connect() might work, if
I only knew what it's supposed to contain... Can anybody shed some light on
this?
--
Romanian Web Developers - http://ROWD.ORG