From: | Rob Brown-Bayliss <rob(at)zoism(dot)org> |
---|---|
To: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
Cc: | PostgreSQL General List <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: uncommited question |
Date: | 2002-08-09 20:55:04 |
Message-ID: | 1028926504.1855.50.camel@everglade.zoism.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
*
From | Date | Subject | |
---|---|---|---|
Next Message | Nigel J. Andrews | 2002-08-09 21:09:03 | Re: oid's and primary keys on insert |
Previous Message | Nigel J. Andrews | 2002-08-09 20:55:01 | Re: oid's and primary keys on insert |