Postgres Pro
Downloads
Home   >   mailing lists

Re: Allow deleting enumerated values from an existing enumerated data type - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Allow deleting enumerated values from an existing enumerated data type
Date
Msg-id 953107.1695911339@sss.pgh.pa.us
Whole thread Raw
In response to Allow deleting enumerated values from an existing enumerated data type  (Данил Столповских <danil.stolpovskikh@gmail.com>)
Responses Re: Allow deleting enumerated values from an existing enumerated data type
List pgsql-hackers
Tree view 
=?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

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Is it worth adding Assert(false) for iso-8859-1 paths in print_path()?
Next
From: David Rowley
Date:
Subject: Re: Is it worth adding Assert(false) for iso-8859-1 paths in print_path()?