From: Wolfgang Wilhelm <wolfgang20121964@yahoo.de>
To: Albe Laurenz <laurenz.albe@wien.gv.at>
To: Thomas Kellerer <spam_eater@gmx.net>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Autocommit off in psql
Date: Wed, 5 Nov 2014 12:56:35 +0000 (UTC)
Message-ID: <1725993116.882216.1415192195154.JavaMail.yahoo@jws11144.mail.ir2.yahoo.com> (raw)
In-Reply-To: <A737B7A37273E048B164557ADEF4A58B17D8C50D@ntex2010i.host.magwien.gv.at>
References: <A737B7A37273E048B164557ADEF4A58B17D8C50D@ntex2010i.host.magwien.gv.at>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Hello Laurenz,
yes, indeed I'm a little confused. I'm not the only one, some Pg-Guys from other companies which I asked about the topic were a little bit puzzled, too.
If this is really a left over and just for portablity when will be time for a clean up? May be not for the next years' version - there should be in good PG manner just an information that this feature is deprecated, if the Hackers agree - but may be for the PG-version of 2017 or 2018?
As you as a contributor are more included in the development of PG code, do you see chances to get that out of the code? If so I'm willing to have a look in the code whether there are comments about that feature.
YoursWolfgang
Albe Laurenz <laurenz.albe@wien.gv.at> schrieb am 11:57 Mittwoch, 5.November 2014:
Wolfgang Wilhelm wrote:
> Thomas Kellerer <spam_eater@gmx.net> schrieb am 9:25 Mittwoch, 5.November 2014:
>>> 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!)> 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.
The autocommit parameter you see with SHOW is a leftover of the removed server feature.
It is there for compatibility reasons (I guess) but is read-only:
test=> SET autocommit=off;
ERROR: SET AUTOCOMMIT TO OFF is no longer supported
You are getting confused because this is a server-side setting (and indeed, there is no way
to turn autocommit off on the server side), whereas \set AUTOCOMMIT is a client side feature.
The latter works by automatically inserting a BEGIN at the appropriate time; nothing
changes on the server side.
Yours,
Laurenz Albe
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: wolfgang20121964@yahoo.de, laurenz.albe@wien.gv.at, spam_eater@gmx.net
Subject: Re: Autocommit off in psql
In-Reply-To: <1725993116.882216.1415192195154.JavaMail.yahoo@jws11144.mail.ir2.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox