BUG #11524: Unable to add value to ENUM when having AUTOCOMMIT disabled in psql

Поиск
Список
Период
Сортировка
От feikesteenbergen@gmail.com
Тема BUG #11524: Unable to add value to ENUM when having AUTOCOMMIT disabled in psql
Дата
Msg-id 20140930104330.7639.71922@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #11524: Unable to add value to ENUM when having AUTOCOMMIT disabled in psql  ("Tomas Vondra" <tv@fuzzy.cz>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      11524
Logged by:          Feike Steenbergen
Email address:      feikesteenbergen@gmail.com
PostgreSQL version: 9.4beta2
Operating system:   Debian
Description:

If I want to add a value to an ENUM type, I cannot do so when having
AUTOCOMMIT enabled.

To reproduce:
\set ECHO queries
CREATE TYPE mood AS ENUM ('sad', 'ok', 'happy');
ALTER TYPE mood ADD VALUE 'autocommit enabled';
\set AUTOCOMMIT OFF
ALTER TYPE mood ADD VALUE 'autocommit disabled';


Output:
CREATE TYPE mood AS ENUM ('sad', 'ok', 'happy');
CREATE TYPE
ALTER TYPE mood ADD VALUE 'autocommit enabled';
ALTER TYPE
ALTER TYPE mood ADD VALUE 'autocommit disabled';
psql:autocommit_enum.sql:5: ERROR:  ALTER TYPE ... ADD cannot run inside a
transaction block

I have this issue on 9.1 - 9.5. (This issue does not occur on 9.0 as adding
"ADD VALUE" was added in 9.1).

This bug reminds me of:
BUG #10822: "ALTER SYSTEM cannot run inside a transaction block" when having
autocommit disabled.

В списке pgsql-bugs по дате отправления:

Предыдущее
От: dmigowski@ikoffice.de
Дата:
Сообщение: BUG #11523: Regular expressions work differently on different platforms
Следующее
От: "Tomas Vondra"
Дата:
Сообщение: Re: BUG #11524: Unable to add value to ENUM when having AUTOCOMMIT disabled in psql