and there are some work-arounds in the archive of this mailing list.
basically use a temporary table.
>From: Alain TESIO <alain_tesio@yahoo.com>
>Reply-To: tesio@easynet.fr
>To: Edouard DESSIOUX <edx@intrinsec.com>, pgsql-general@postgresql.org
>Subject: Re: [GENERAL] Alter table possibility
>Date: Tue, 9 Nov 1999 08:24:31 -0800 (PST)
>
>--- Edouard DESSIOUX <edx@intrinsec.com> wrote:
> > I've just seen that alter allow to add a column
> > But how can I do if I want to delete a column ?
>
>Scroll down a bit on the same page in the manual and
>you'll read that this feature (alter table drop column)
>is not yet supported.
>
>Alain
>
>
>__________________________________________________
>Do You Yahoo!?
>Bid and sell for free at http://auctions.yahoo.com
>
>************
>
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com