Horton

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

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Данил Столповских <danil.stolpovskikh@gmail.com>
Cc: pgsql-hackers@postgresql.org, o.tselebrovskiy@postgrespro.ru, d.frolov@postgrespro.ru
Date: 2023-09-28T14:28:59Z
Lists: pgsql-hackers 
=?UTF-8?B?0JTQsNC90LjQuyDQodGC0L7Qu9C/0L7QstGB0LrQuNGF?= <danil.stolpovskikh@gmail.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

Commits

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