postgres - update enum values

postgres_alter_enum.txt

// https://blog.yo1.dog/updating-enum-values-in-postgresql-the-safe-and-easy-way/

ADD VALUE (PG 9.x)
=========
# PG 9.6: works from flyway.
ALTER TYPE AUDIT_DATABASE_EVENT_TYPE ADD VALUE 'foo';

RENAME VALUE (PG 10.x)
=============
# PG 10.+: works from flyway (not supported in PG 9.x)
ALTER TYPE AUDIT_DATABASE_EVENT_TYPE RENAME VALUE 'foo' TO 'bar';


# more tricks ...
see: https://blog.yo1.dog/updating-enum-values-in-postgresql-the-safe-and-easy-way/