Re: an already existing alter table drop column ?!?!?!

From: "Gowey, Geoffrey" <ggowey(at)rxhope(dot)com>
To: "'Marc G(dot) Fournier'" <scrappy(at)hub(dot)org>, "Gowey, Geoffrey" <ggowey(at)rxhope(dot)com>
Cc: "'Hiroshi Inoue'" <Inoue(at)tpf(dot)co(dot)jp>, Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: an already existing alter table drop column ?!?!?!
Date: 2001-09-24 17:35:05
Message-ID: E15F4B031E17D5118B18009027F67927DAFB@SERVER
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)hub(dot)org]
Sent: Monday, September 24, 2001 1:28 PM
To: Gowey, Geoffrey
Cc: 'Hiroshi Inoue'; Stephan Szabo; pgsql-hackers(at)postgresql(dot)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(at)hub(dot)org]
> Sent: Monday, September 24, 2001 1:14 PM
> To: Gowey, Geoffrey
> Cc: 'Hiroshi Inoue'; Stephan Szabo; pgsql-hackers(at)postgresql(dot)org
> Subject: Re: [HACKERS] an already existing alter table drop column
> ?!?!?!
>
>
>
> isn't
>

Browse pgsql-hackers by date

  From Date Subject
Next Message Gowey, Geoffrey 2001-09-24 17:48:59 Re: an already existing alter table drop column ?!?!?!
Previous Message Marc G. Fournier 2001-09-24 17:28:16 Re: an already existing alter table drop column ?!?!?!