Re: an already existing alter table drop column ?!?!?!
От | Gowey, Geoffrey |
---|---|
Тема | Re: an already existing alter table drop column ?!?!?! |
Дата | |
Msg-id | E15F4B031E17D5118B18009027F67927DAFB@SERVER обсуждение исходный текст |
Ответ на | an already existing alter table drop column ?!?!?! ("Gowey, Geoffrey" <ggowey@rxhope.com>) |
Список | 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 по дате отправления: