Re: [HACKERS] alter table..drop constraint pkey, left not null un-dropped

2017-05-11 Thread Tom Lane
Rajkumar Raghuwanshi writes: > I have created a table with primary key, and then dropped primary key from > table. But table still have not null constraint added by primary key. > Is there any other statement to delete primary key with not null? > or this is an expected behaviour of pg? Yes, it'

Re: [HACKERS] alter table..drop constraint pkey, left not null un-dropped

2017-05-11 Thread Ashutosh Bapat
On Thu, May 11, 2017 at 3:03 PM, Rajkumar Raghuwanshi wrote: > Hi All, > > I have created a table with primary key, and then dropped primary key from > table. But table still have not null constraint added by primary key. > > Is there any other statement to delete primary key with not null? > or t

[HACKERS] alter table..drop constraint pkey, left not null un-dropped

2017-05-11 Thread Rajkumar Raghuwanshi
Hi All, I have created a table with primary key, and then dropped primary key from table. But table still have not null constraint added by primary key. Is there any other statement to delete primary key with not null? or this is an expected behaviour of pg? postgres=# create table tbl (c1 int p