From: | Postgres DBA <postgres(at)nest(dot)bistbn(dot)com> |
---|---|
To: | Kevin Heflin <kheflin(at)shreve(dot)net> |
Cc: | "PGSQL-General (E-mail)" <pgsql-general(at)postgreSQL(dot)org> |
Subject: | Re: [GENERAL] alter table ? |
Date: | 1998-11-13 08:04:31 |
Message-ID: | Pine.BSF.4.02.9811130959340.27705-100000@nest.bistbn.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)shreve(dot)net | Shreveport, LA 71101 | http://www.shreve.net
> --------------------------------------------------------------------
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Sergei Chernev | 1998-11-13 08:22:50 | PL/pgSQL |
Previous Message | Sven Hartrumpf | 1998-11-13 07:56:16 | PGSQL 6.4 and C++ Functions |