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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Stefan Kunick" <stefan(at)kunick(dot)org>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3925: You can delete enum elements from pg_enum, but it is used in a table
Date: 2008-02-02 20:40:15
Message-ID: 10071.1201984815@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Stefan Kunick" <stefan(at)kunick(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Andreas 2008-02-03 11:14:39 BUG #3926: Typo in documentation
Previous Message Heikki Linnakangas 2008-02-02 20:35:12 Re: BUG #3924: Create Database with another encoding as the encoding from postgres