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-0004Hz-FF@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
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/d97e98e8337e915e3404f7b2a8a6b966b6f5394f

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


pgsql-committers by date:

Previous
From: Fujii Masao
Date:
Subject: pgsql: Prevent psql from issuing BEGIN before ALTER SYSTEM when AUTOCOM
Next
From: Tom Lane
Date:
Subject: pgsql: Add some errdetail to checkRuleResultList().