Re: Allow deleting enumerated values from an existing enumerated data type

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Данил Столповских <danil(dot)stolpovskikh(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org, 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 14:28:59
Message-ID: 953107.1695911339@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

=?UTF-8?B?0JTQsNC90LjQuyDQodGC0L7Qu9C/0L7QstGB0LrQuNGF?= <danil(dot)stolpovskikh(at)gmail(dot)com> writes:
> 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>

This does not fix any of the hard problems that caused us not to
have such a feature to begin with. Notably, what happens to
stored data of the enum type if it is a now-deleted value?

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David Rowley 2023-09-28 14:55:33 Re: Is it worth adding Assert(false) for unknown paths in print_path()?
Previous Message Tom Lane 2023-09-28 14:23:43 Re: Is it worth adding Assert(false) for unknown paths in print_path()?