Yes, I meant turn off Autocommit for the entire psql session.
Starting every manipulation of the database with a BEGIN is
a bit tiresome, and i often catch myself with forgetting it.
If it isn't possible, it would be a nice featue!?
Björn
Tim Mickol wrote:
> 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?
>
>
> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
