Potential bug in ALTER TABLE?

From: Jeroen Ruigrok/asmodai <asmodai(at)wxs(dot)nl>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Potential bug in ALTER TABLE?
Date: 2003-09-04 14:02:19
Message-ID: 20030904140219.GI42098@nexus.ninth-circle.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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...

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2003-09-04 14:19:05 Re: Potential bug in ALTER TABLE?
Previous Message Ben Grimm 2003-09-04 12:59:37 pg_dump/all doesn't output schemas correctly (v7.3.4)