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