Yeah, that's true, but you can simply overcome this problem with following
query that you should issue right after "alter" query:
update passwd set spamblock='TRUE';
Aleksey.
On Thu, 12 Nov 1998, Kevin Heflin wrote:
>
> I went to alter a table, to add a column like so:
>
> alter table passwd add column spamblock bool DEFAULT 'TRUE'
>
> this added the new column of type bool but did not make the default true.
>
> Any suggestions?
>
> Kevin
>
>
> --------------------------------------------------------------------
> Kevin Heflin | ShreveNet, Inc. | Ph:318.222.2638 x103
> VP/Mac Tech | 333 Texas St #619 | FAX:318.221.6612
> kheflin@shreve.net | Shreveport, LA 71101 | http://www.shreve.net
> --------------------------------------------------------------------
>
>
>