Re: [HACKERS] ALTER .. ADD PRIMARY KEY

2002-12-02 Thread Christopher Kings-Lynne
cember 02, 2002 12:31 PM Subject: [HACKERS] ALTER .. ADD PRIMARY KEY Right now ALTER .. ADD PRIMARY KEY insists that the columns must be NOT NULL first. I'd like to change it so that it automatically creates the NOT NULL constraint (same as CREATE TABLE). I didn't see anyt

Re: [HACKERS] ALTER .. ADD PRIMARY KEY

2002-12-02 Thread Christopher Kings-Lynne
cember 02, 2002 12:31 PM Subject: [HACKERS] ALTER .. ADD PRIMARY KEY Right now ALTER .. ADD PRIMARY KEY insists that the columns must be NOT NULL first. I'd like to change it so that it automatically creates the NOT NULL constraint (same as CREATE TABLE). I didn't see anyt

[HACKERS] ALTER .. ADD PRIMARY KEY

2002-12-02 Thread Rod Taylor
Right now ALTER .. ADD PRIMARY KEY insists that the columns must be NOT NULL first. I'd like to change it so that it automatically creates the NOT NULL constraint (same as CREATE TABLE). I didn't see anything in the spec for or against doing this automatically. I believe the best way to do this