| From: | Vik Fearing <vik(at)postgresfriends(dot)org> |
|---|---|
| To: | Данил Столповских <danil(dot)stolpovskikh(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Cc: | o(dot)tselebrovskiy(at)postgrespro(dot)ru, d(dot)frolov(at)postgrespro(dot)ru |
| Subject: | Re: Allow deleting enumerated values from an existing enumerated data type |
| Date: | 2023-09-28 13:50:58 |
| Message-ID: | 88d0151c-a609-86e6-d2ea-d0437e68d615@postgresfriends.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 9/28/23 14:13, Данил Столповских wrote:
> 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
Thanks for this patch that a lot of people want.
However, it does not seem to address the issue of how to handle the
dropped value being in the high key of an index. Until we solve that
problem (and maybe others), this kind of patch is insufficient to add
the feature.
--
Vik Fearing
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2023-09-28 13:57:15 | Re: Set enable_seqscan doesn't take effect? |
| Previous Message | Peter Eisentraut | 2023-09-28 13:50:43 | pg_resetwal: Corrections around -c option |