Re: [GENERAL] alter table ? - Mailing list pgsql-general

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
> --------------------------------------------------------------------
>
>
>