Bug of ALTER TABLE DROP CONSTRAINT

From: "Jacky Leng" <lengjianquan(at)163(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Bug of ALTER TABLE DROP CONSTRAINT
Date: 2009-04-02 07:25:21
Message-ID: gr1p91$flr$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Heikki Linnakangas 2009-04-02 07:47:37 Re: 8.4 open items list
Previous Message Tino Wildenhain 2009-04-02 06:22:32 Re: [GENERAL] string_to_array with empty input