| From: | Thomas Kellerer <spam_eater(at)gmx(dot)net> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Autocommit off in psql |
| Date: | 2014-11-05 08:24:40 |
| Message-ID: | m3cms9$f0j$1@ger.gmane.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Wolfgang Wilhelm | 2014-11-05 10:17:23 | Re: Autocommit off in psql |
| Previous Message | Wolfgang Wilhelm | 2014-11-05 08:08:32 | Autocommit off in psql |