Actually, I think the original question alluded to SQL*PLUS behavior that
allows one to disable autocommit for an ENTIRE session,
not simply a discrete transaction. In psql, in order to enforce
autocommit=off for an entire session, you must repeatedly issue a series of
BEGIN directives, one following each ROLLBACK, COMMIT, or ABORT, yes?
tjm
-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of Neil Conway
Sent: Tuesday, May 22, 2001 3:49 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Autocommit off in psql??
On Mon, May 21, 2001 at 09:38:11PM +0200, Bj?rn Lundin wrote:
> Hi!
> Is there a way of turning autocommit of in psql ?
> It would be nice for people used to Oracle's SQL*Plus.
> No fatal error has occurred yet, but some minor problems could have been
> avoided if rollback was possible when the fingers on the keyboard are
> faster than the brain :)
Yes, just start an explicit transaction with "BEGIN" -- this disables
autocommit (so when you want to commit your transaction, you'll need
to do "COMMIT" by hand).
Cheers,
Neil
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster