[HACKERS] Bug of ALTER TABLE DROP CONSTRAINT

[Jacky Leng]

Considering the following sequence:
    create table t(a int primary key);
    alter table t drop constraint t_pkey;
    insert into 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.



-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers