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

Поиск
Список
Период
Сортировка
От Stefan Kunick
Тема BUG #3925: You can delete enum elements from pg_enum, but it is used in a table
Дата
Msg-id 200802021920.m12JKmZC006493@wwwmaster.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #3925: You can delete enum elements from pg_enum, but it is used in a table  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      3925
Logged by:          Stefan Kunick
Email address:      stefan@kunick.org
PostgreSQL version: 8.3RC2
Operating system:   Windows Longhorn
Description:        You can delete enum elements from pg_enum, but it is
used in a table
Details:

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.

When you access to the table some programs stopped with a error.

Can we check in the delete statement that the element ist used in a table?

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: BUG #3924: Create Database with another encoding as the encoding from postgres
Следующее
От: "Heikki Linnakangas"
Дата:
Сообщение: Re: BUG #3924: Create Database with another encoding as the encoding from postgres