Re: [HACKERS] Well, then you keep your darn columns

Поиск
Список
Период
Сортировка
От Hannu Krosing
Тема Re: [HACKERS] Well, then you keep your darn columns
Дата
Msg-id 388E462C.D7DCAC4D@tm.ee
обсуждение исходный текст
Ответ на Re: [HACKERS] Well, then you keep your darn columns  (The Hermit Hacker <scrappy@hub.org>)
Список pgsql-hackers
The Hermit Hacker wrote:
> 
> > numbered.  How does a missing attribute get handled for new rows?
> > My guess is that we have to keep this thing around forever.  Can you
> > imagine having all those user apps tha query pg_attribute supress that
> > column.  Sound like too much work to me.
> 
> I *still* think the best is the "re-write the table in place" method
> ... we already have most of the logic, I would think, from VACUUM ...

It is much safer with vacuum, as there is no way for vacuum to crash and have 
two different tuple formats left behind (i hope ;-p)

-------------
Hannu


В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Oliver Elphick"
Дата:
Сообщение: Re: [HACKERS] Column ADDing issues
Следующее
От: Hannu Krosing
Дата:
Сообщение: Re: Happy column adding (was RE: [HACKERS] Happycolumndropping)