Re: Autocommit off in psql

Wolfgang Wilhelm schrieb am 05.11.2014 um 09:08:
> There's an annoying difference between the database command line
> tools. Oracle doesn't have a BEGIN for a transaction start but needs
> a commit for saving changes. Psql on the other hand requires BEGIN to
> start an transaction or it will be in autocommit mode. Guess how much
> not so nice words I've heard in the last days because my team forgets
> that transaction begin...
>
> Is there any way to make psql work a little bit more like sqlplus?
> "Set autocommit off" is obviously no solution as it's not valid
> anymore.

You can use

   \set AUTOCOMMIT off

in psql to turn off autocommit mode (note that this is case-sensitive!)

I have that line in my psqlrc file so autocommit is automatically turned off.
(although I rarely use psql or sqlplus)


Regards
Thomas