Bug of ALTER TABLE DROP CONSTRAINT - Mailing list pgsql-hackers

From Jacky Leng
Subject Bug of ALTER TABLE DROP CONSTRAINT
Date
Msg-id gr1p91$flr$1@news.hub.org
Whole thread Raw
Responses Re: Bug of ALTER TABLE DROP CONSTRAINT  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Considering the following sequence:   create table t(a int primary key);   alter table t drop constraint t_pkey;
insertinto t values(null);   ERROR:  null value in column "a" violates not-null constraint
 

My question is, why "null" is not allowed to be inserted after primary key 
constraint has been dropped.




pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: 8.4 open items list
Next
From: Dave Page
Date:
Subject: Re: 8.4 open items list