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 [EMAIL PROTECTED]) > ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
