Re: [BUGS] BUG #3925: You can delete enum elements from pg_enum, but it is used in a table

From: Tom Lane <tgl(at)sss.pgh.pa.us>
Date: Sat Feb 02 2008 - 15:40:15 EST

"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

---------------------------(end of broadcast)---------------------------

TIP 4: Have you searched our list archives?

               http://archives.postgresql.org Received on Sat Feb 2 15:41:53 2008