alter table questions

From: "mike" <matrix(at)quadrent(dot)net>
To: <pgsql-general(at)postgresql(dot)org>
Subject: alter table questions
Date: 2001-04-23 14:36:27
Message-ID: 001801c0cc02$c77ec9f0$0100000a@Domain.wyd2002.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

in the current postgres docs alter table is as follows to add a column,

ALTER TABLE distributors ADD COLUMN address VARCHAR(30);

why is it when I add a column with a defualt value the default value is ignored?
ALTER TABLE ind_personal ADD COLUMN reg_security CHAR(3) NOT NULL DEFAULT '0';

Mike


Responses

Browse pgsql-general by date

  From Date Subject
Next Message Toy 2001-04-23 15:09:13 general storage question
Previous Message Sebastian Bossung 2001-04-23 14:15:23 Detecting locks