Vince Vielhaber <[EMAIL PROTECTED]> 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 rout
On 8 May 2001, Nabil Sayegh wrote:
> On 05 May 2001 12:23:37 -0400, [EMAIL PROTECTED] wrote:
> > Vince Vielhaber ([EMAIL PROTECTED]) reports a bug with a severity of 3
> > The lower the number the more severe it is.
> >
> > Short Description
> > Alter table add column ignores default
> >
> > Long
On 8 May 2001, Nabil Sayegh wrote:
> 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 defaul
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 fooba
On 05 May 2001 12:23:37 -0400, [EMAIL PROTECTED] wrote:
> Vince Vielhaber ([EMAIL PROTECTED]) reports a bug with a severity of 3
> The lower the number the more severe it is.
>
> Short Description
> Alter table add column ignores default
>
> Long Description
> Alter table add column ignores the
Vince Vielhaber ([EMAIL PROTECTED]) reports a bug with a severity of 3
The lower the number the more severe it is.
Short Description
Alter table add column ignores default
Long Description
Alter table add column ignores the default values in both v7.0x and 7.1. In the
example code the table is
