Horton
Menu

Re: Alter table add column ignores default

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Vince Vielhaber <vev@michvhf.com>
Cc: Nabil Sayegh <nsmail@sayegh.de>, vev@hub.org, pgsql-bugs@postgresql.org
Date: 2001-05-11T13:47:06Z
Lists: pgsql-bugs 
Vince Vielhaber <vev@michvhf.com> writes:
> If this:
> alter table foobar add column address varchar(50) default 'none';
> is the incorrect syntax, why does it not fail or at least give a
> warning?

Because it's incompletely implemented: the parser takes the full syntax
but the ALTER TABLE routine doesn't do everything it should.

			regards, tom lane