> In PostgreSQL, schema changes are transactional.
With a few exceptions (that refuse to run in an explicit transaction): E.g. {CREATE, DROP} DATABASE, {CREATE, DROP} TABLESPACE, {CREATE INDEX, DROP INDEX, REINDEX} CONCURRENTLY, REINDEX {SCHEMA, SYSTEM, DATABASE}.
commit 212fab9926b2f0f04b0187568e7124b70e8deee5
Author: Thomas Munro <tmunro@postgresql.org>
Date: 2018-10-09 12:51:01 +1300
Relax transactional restrictions on ALTER TYPE ... ADD VALUE (redux).
There's still some restrictions:
> This patch removes that restriction, and instead insists that an uncommitted enum value can't be referenced unless it belongs to an enum type created in the same transaction as the value.
With a few exceptions (that refuse to run in an explicit transaction): E.g. {CREATE, DROP} DATABASE, {CREATE, DROP} TABLESPACE, {CREATE INDEX, DROP INDEX, REINDEX} CONCURRENTLY, REINDEX {SCHEMA, SYSTEM, DATABASE}.