I do like the flag idea as a temporary patch until a fully workable solution
is available. Just run a delete on the column and then flag it so it takes
up no space and is hidden. By doing this now a more perfect solution can be
found later.
Geoff
-----Original Message-----
From: Marc G. Fournier [mailto:scrappy@hub.org]
Sent: Monday, September 24, 2001 1:28 PM
To: Gowey, Geoffrey
Cc: 'Hiroshi Inoue'; Stephan Szabo; pgsql-hackers@postgresql.org
Subject: RE: [HACKERS] an already existing alter table drop column
?!?!?!
On Mon, 24 Sep 2001, Gowey, Geoffrey wrote:
> damn. Is there a usable version being worked around? If so, how long
before
> it is available?
too many dissending opinions on how it should (and shouldn't) be done ...
the one that was put in pre-maturely needed 2x the disk space to do ... so
if you had a multi-gig table, you had to have enough free space to store a
second copy in order to remove a column ...
there was a bunch of us that felt that it could be done better using a
'flag' on the column so that it was hidden ... and some that thought ...
etc, etc ...
> > Geoff
>
> -----Original Message-----
> From: Marc G. Fournier [mailto:scrappy@hub.org]
> Sent: Monday, September 24, 2001 1:14 PM
> To: Gowey, Geoffrey
> Cc: 'Hiroshi Inoue'; Stephan Szabo; pgsql-hackers@postgresql.org
> Subject: Re: [HACKERS] an already existing alter table drop column
> ?!?!?!
>
>
>
> isn't
>
