Re: Fast AT ADD COLUMN with DEFAULTs

Поиск
Список
Период
Сортировка
От Vitaly Burovoy
Тема Re: Fast AT ADD COLUMN with DEFAULTs
Дата
Msg-id CAKOSWNkSz97-rvNX9+=isfqrNHrkrk+ABn7ANngxJ0f4Dj9F7g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Fast AT ADD COLUMN with DEFAULTs  (Vitaly Burovoy <vitaly.burovoy@gmail.com>)
Список pgsql-hackers
On 10/6/16, Vitaly Burovoy <vitaly.burovoy@gmail.com> wrote:
> Ough. I made a mistake about pg_attribute because I forgot about the
> pg_attrdef.
> If we do not merge these tables, the pg_attrdef is the best place to
> store evaluated expression as a constant the same way defaults are
> stored in adbin.

Oops. While I was writing the previous email, Tom explained necessity
of the pg_attrdef.
With that explanation it is obvious that I was wrong and a value for
pre-existing rows should be in a new column in the pg_attribute.
All the other thoughts from my previous email stand good.

-- 
Best regards,
Vitaly Burovoy



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

Предыдущее
От: Vitaly Burovoy
Дата:
Сообщение: Re: Fast AT ADD COLUMN with DEFAULTs
Следующее
От: Serge Rielau
Дата:
Сообщение: Re: Fast AT ADD COLUMN with DEFAULTs