Allow deleting enumerated values from an existing enumerated data type

From: Данил Столповских <danil(dot)stolpovskikh(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Cc: o(dot)tselebrovskiy(at)postgrespro(dot)ru, d(dot)frolov(at)postgrespro(dot)ru
Subject: Allow deleting enumerated values from an existing enumerated data type
Date: 2023-09-28 12:13:29
Message-ID: CAG7W4rpQn5vwKJ99sbXkdhgahPSCu=hOZhRqAq8i=ScAH8HRUg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Attachment Content-Type Size
enum_drop_value.patch text/x-patch 10.7 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Drouvot, Bertrand 2023-09-28 12:37:02 Add a new BGWORKER_BYPASS_ROLELOGINCHECK flag
Previous Message Daniel Gustafsson 2023-09-28 12:02:57 Re: Out of memory error handling in frontend code