From: | "Stefan Kunick" <stefan(at)kunick(dot)org> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #3925: You can delete enum elements from pg_enum, but it is used in a table |
Date: | 2008-02-02 19:20:48 |
Message-ID: | 200802021920.m12JKmZC006493@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 3925
Logged by: Stefan Kunick
Email address: stefan(at)kunick(dot)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?
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2008-02-02 19:45:12 | Re: BUG #3924: Create Database with another encoding as the encoding from postgres |
Previous Message | Stefan Kunick | 2008-02-02 19:01:08 | BUG #3924: Create Database with another encoding as the encoding from postgres |