Re: BUG #3925: You can delete enum elements from pg_enum, but it is used in a table - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #3925: You can delete enum elements from pg_enum, but it is used in a table
Date
Msg-id 10071.1201984815@sss.pgh.pa.us
Whole thread Raw
In response to BUG #3925: You can delete enum elements from pg_enum, but it is used in a table  ("Stefan Kunick" <stefan@kunick.org>)
List pgsql-bugs
"Stefan Kunick" <stefan@kunick.org> writes:
> I create a enumeration. After this, i used the enumeration in a table. I
> delete the enumeration in the table pg_enum (delete from pg_enum where
> enumtypid=16631 and enumlabel='center'; The delete don't check, that the
> element is used in a table.

Manual modifications of the system catalogs are not supported.  If you
choose to do that, it's on your own head whether the results are sane.

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Heikki Linnakangas"
Date:
Subject: Re: BUG #3924: Create Database with another encoding as the encoding from postgres
Next
From: "Andreas"
Date:
Subject: BUG #3926: Typo in documentation