Potential bug in ALTER TABLE?
От | Jeroen Ruigrok/asmodai |
---|---|
Тема | Potential bug in ALTER TABLE? |
Дата | |
Msg-id | 20030904140219.GI42098@nexus.ninth-circle.org обсуждение исходный текст |
Ответы |
Re: Potential bug in ALTER TABLE?
Re: Potential bug in ALTER TABLE? |
Список | pgsql-hackers |
Hi, just want to verify first with you guys before dumping it on the bugs list. Most likely I am just being silly here or something. Take this: create table blah (name TEXT CHECK (name IN ('blah', 'bleh'))); test=# \d blah Table "public.blah"Column | Type | Modifiers --------+------+-----------name | text | Check constraints: "blah_name" ((name = 'blah'::text) OR (name = 'bleh'::text)) As we would expect PostgreSQL to do. The constraint has an automatically assigned name. Now, to continue: ALTER TABLE blah DROP CONSTRAINT blah_name; ALTER TABLE blah ADD CHECK (name IN ('blah', 'bleh')); test=# \d blah Table "public.blah"Column | Type | Modifiers --------+------+-----------name | text | Check constraints: "$1" ((name = 'blah'::text) OR (name = 'bleh'::text)) And this time around PostgreSQL doesn't assign an automatic name. Well, it depends on what you call a name, but $1, $2, and so on isn't quite descriptive. Is this an oversight or am I missing some subtle thing here? -- Jeroen Ruigrok van der Werven <asmodai(at)wxs.nl> / asmodai PGP fingerprint: 2D92 980E 45FE 2C28 9DB7 9D88 97E6 839B 2EAC 625B http://www.tendra.org/ | http://www.in-nomine.org/~asmodai/diary/ Happiness is the absence of the striving for happiness...
В списке pgsql-hackers по дате отправления: