Hi,
I am absolutely sure a certain value of one of my ENUM types is not used in
the entire database. Now I am asked to drop that value. Unfortunately,
there is no ALTER TYPE DROP VALUE.
On my development box I tried
delete from pg_enum
where enumtypid='my_type_name'::regtype
and enumlabel='my_label'
It worked and I could not find any adverse effects.
Given the value is not used anywhere, is this a save command?
Thanks,
Torsten