Postgres Pro
Downloads
Home   >   mailing lists

ALTER TYPE ... ADD VALUE issue - Mailing list pgsql-general

From Victor Yegorov
Subject ALTER TYPE ... ADD VALUE issue
Date
Msg-id CAGnEbohD7bcQ3_R4qC9pPOj73KSjPFVNXbgRT2RQE7EPz6+wkA@mail.gmail.com
Whole thread Raw
Responses Re: ALTER TYPE ... ADD VALUE issue  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view
Greetings.


I'm observing the following on 9.3.5 and also on 9.4beta3:

\set AUTOCOMMIT on
CREATE TYPE enum_type AS ENUM ('bad', 'good');
CREATE TYPE
ALTER TYPE enum_type ADD VALUE 'so-so' AFTER 'bad';
ALTER TYPE
DROP TYPE enum_type;
DROP TYPE;
\set AUTOCOMMIT off
CREATE TYPE enum_type AS ENUM ('bad', 'good');
CREATE TYPE
COMMIT;
COMMIT
ALTER TYPE enum_type ADD VALUE 'so-so' AFTER 'bad';
ERROR:  ALTER TYPE ... ADD cannot run inside a transaction block


What is wrong here?


--
Victor Y. Yegorov

pgsql-general by date:

Previous
From: David G Johnston
Date:
Subject: Re: problem in to_char( ) ?
Next
From: Adrian Klaver
Date:
Subject: Re: ALTER TYPE ... ADD VALUE issue