Re: an already existing alter table drop column ?!?!?! - Mailing list pgsql-hackers

From Gowey, Geoffrey
Subject Re: an already existing alter table drop column ?!?!?!
Date
Msg-id E15F4B031E17D5118B18009027F67927DAFB@SERVER
Whole thread Raw
In response to an already existing alter table drop column ?!?!?!  ("Gowey, Geoffrey" <ggowey@rxhope.com>)
List pgsql-hackers
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
>


pgsql-hackers by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: Re: an already existing alter table drop column ?!?!?!
Next
From: "Gowey, Geoffrey"
Date:
Subject: Re: an already existing alter table drop column ?!?!?!