On Sat, 2002-08-10 at 08:11, Rob Brown-Bayliss wrote:
> Yeah, I thought postgresql had by default the auto-commit thing? Is it
> a config setup somewhere?
For interested parties (from the docs to 7.1.3):
By default, Postgres executes transactions in unchained mode (also known
as "autocommit" in other database systems). In other words, each user
statement is executed in its own transaction and a commit is implicitly
performed at the end of the statement (if execution was successful,
otherwise a rollback is done). BEGIN initiates a user transaction in
chained mode, i.e., all user statements after BEGIN command will be
executed in a single transaction until an explicit COMMIT, ROLLBACK, or
execution abort.
--
*
* Rob Brown-Bayliss
*