pgsql: Prevent psql from issuing BEGIN before ALTER SYSTEM when AUTOCOM - Mailing list pgsql-committers

From Fujii Masao
Subject pgsql: Prevent psql from issuing BEGIN before ALTER SYSTEM when AUTOCOM
Date
Msg-id E1X2BiZ-0004I0-FK@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Prevent psql from issuing BEGIN before ALTER SYSTEM when AUTOCOMMIT is off.

The autocommit-off mode works by issuing an implicit BEGIN just before
any command that is not already in a transaction block and is not itself
a BEGIN or other transaction-control command, nor a command that
cannot be executed inside a transaction block. This commit prevents psql
from issuing such an implicit BEGIN before ALTER SYSTEM because it's
not allowed inside a transaction block.

Backpatch to 9.4 where ALTER SYSTEM was added.

Report by Feike Steenbergen

Branch
------
REL9_4_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/5520006b5bbaa36e6734a8ccf960bb870f4a4fec

Modified Files
--------------
src/bin/psql/common.c |   17 +++++++++++++++++
1 file changed, 17 insertions(+)


pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql: Allow CREATE/ALTER DATABASE to manipulate datistemplate and data
Next
From: Fujii Masao
Date:
Subject: pgsql: Prevent psql from issuing BEGIN before ALTER SYSTEM when AUTOCOM