pgsql: Prevent psql from issuing BEGIN before ALTER SYSTEM when AUTOCOM

Поиск
Список
Период
Сортировка
От Fujii Masao
Тема pgsql: Prevent psql from issuing BEGIN before ALTER SYSTEM when AUTOCOM
Дата
Msg-id E1X2BiZ-0004I0-FK@gemulon.postgresql.org
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: pgsql: Allow CREATE/ALTER DATABASE to manipulate datistemplate and data
Следующее
От: Fujii Masao
Дата:
Сообщение: pgsql: Prevent psql from issuing BEGIN before ALTER SYSTEM when AUTOCOM