Re: alter table

Yuri,

You are correct that the alter table syntax does not
support changing the data type of a column or dropping
a column.

I've never added a column with default values, so I
could be wrong here; but if your new column contains
integers, shouldn't the default value be mentioned
without the single quotes?

Best of luck,

Andrew Gould

--- "Yuri A. Kabaenkov" <sec(at)artofit(dot)com> wrote:
> Hello,
>
> I've read documentation on alter table syntax
> and doesn't find
> anything about change column type or drop
> column.
>
> Also when i add column by command
> alter table test add column a integer not null
> default '10'
>
> It adds column but doesn't set default value.
>
> How can i fix it?
>
>
>
> ------------
> With respect,
> Yuri A. Kabaenkov
> hellman(at)artofit(dot)com
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the
> unregister command
> (send "unregister YourEmailAddressHere" to
majordomo(at)postgresql(dot)org)

__________________________________________________
Do You Yahoo!?
Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.
http://geocities.yahoo.com/ps/info1