Re: Alter table add column ignores default

On 08 May 2001 10:31:17 -0400, Vince Vielhaber wrote:
> > http://hermes.swu.bg/postgres/postgres/sql-altertable.htm
> > The correct syntax is:
> > ALTER TABLE foobar add column address varchar(50);
> > ALTER TABLE foobar alter column address set default 'none';
> 
> 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?



Sorry, I meant: Try this workaround :)


cu

--
 Nabil Sayegh