Re: Allow deleting enumerated values from an existing enumerated data type
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Vik Fearing <vik@postgresfriends.org>
Cc: Andrew Dunstan <andrew@dunslane.net>, Данил Столповских <danil.stolpovskikh@gmail.com>, pgsql-hackers@postgresql.org, o.tselebrovskiy@postgrespro.ru, d.frolov@postgrespro.ru
Date: 2023-09-29T01:17:09Z
Lists: pgsql-hackers
Vik Fearing <vik@postgresfriends.org> writes: > On 9/28/23 20:46, Tom Lane wrote: >> We went through all these points years ago when the enum feature >> was first developed, as I recall. Nobody thought that the ability >> to remove an enum value was worth the amount of complexity it'd >> entail. > This issue comes up regularly (although far from often). Do we want to > put some comments right where would-be implementors would be sure to see it? Perhaps. I'd be kind of inclined to leave the "yet" out of "not yet implemented" in the error message, as that wording sounds like we just haven't got round to it. regards, tom lane
Commits
-
Add some notes about why "ALTER TYPE enum DROP VALUE" is hard.
- af3ee8a086ca 17.0 landed