Horton

Allow deleting enumerated values from an existing enumerated data type

Данил Столповских <danil.stolpovskikh@gmail.com>

View thread View on postgr.es
From: Данил Столповских <danil.stolpovskikh@gmail.com>
To: pgsql-hackers@postgresql.org
Cc: o.tselebrovskiy@postgrespro.ru, d.frolov@postgrespro.ru
Date: 2023-09-28T12:13:29Z
Lists: pgsql-hackers

Attachments

Greetings, everyone!
I would like to offer my patch on the problem of removing values from enums

It adds support for expression ALTER TYPE <enum_name> DROP VALUE
<value_name>

Added:
1. expression in grammar
2. function to drop enum values
3. regression tests
4. documentation

Commits

  1. Add some notes about why "ALTER TYPE enum DROP VALUE" is hard.