ALTER enum

Data publikacji: Oct 16, 2009 11:46:30 AM

(...)

COMMENT ON FUNCTION enum.enum_add (enum_name character varying, enum_elem character varying) IS 'Inserts a new ENUM element wthout re-creating the whole type.';

COMMENT ON FUNCTION enum.enum_del (enum_name character varying, enum_elem character varying) IS 'Removes the ENUM element "on the fly". Check references to the ENUM element in database''s tables before the deletion and throws an exception if the element cannot be deleted.';

(źródło: http://dklab.ru/lib/dklab_postgresql_enum/)