Postgres Pro
Downloads
Home   >   mailing lists

Re: Autocommit off in psql - Mailing list pgsql-admin

From Wolfgang Wilhelm
Subject Re: Autocommit off in psql
Date
Msg-id 656182952.847732.1415182643649.JavaMail.yahoo@jws11170.mail.ir2.yahoo.com
Whole thread Raw
In response to Re: Autocommit off in psql  (Thomas Kellerer <spam_eater@gmx.net>)
Responses Re: Autocommit off in psql  (Albe Laurenz <laurenz.albe@wien.gv.at>)
List pgsql-admin
Tree view
Hello Thomas,

first of all thank you for your answer.
This is basically what I found via Google, too, but is that up to date information? I found some more info that that setting isn't valid anymore.
When I do that command which you sent, it seems to execute but when I do

show AUTOCOMMIT;

I get as as a result:

 autocommit
------------
 on
(1 line)

When I do the command which you mentioned with a semicolon at the end I get an error message: Unknow boolean value: "on" assumed - well, at least I guess it should be something like that because I get that in german.
I tried with several other boolean values like 0, false, none, all with the same result of show AUTOCOMMIT;

Just a minute ago I realized that the output of show AUTOCOMMIT is somehow, well, misleading. First I did setting autocommit off. Then I inserted some data in a table. Another insert, a third. If autocommit would be on I'd expect it to do a commit after every insert. But a rollback made them all three disappear. I found that in the help text of the show command AUTOCOMMIT is not included. The question is why show outputs some info. But that shouldn't be your problem.

Thank you for you assistance!

Regards
Wolfgang





Thomas Kellerer <spam_eater@gmx.net> schrieb am 9:25 Mittwoch, 5.November 2014:




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




--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin



pgsql-admin by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: Autocommit off in psql
Next
From: Albe Laurenz
Date:
Subject: Re: Autocommit off in psql