ALTER TABLE ADD COLUMN fast default

Поиск
Список
Период
Сортировка
От Andrew Dunstan
Тема ALTER TABLE ADD COLUMN fast default
Дата
Msg-id 31e2e921-7002-4c27-59f5-51f08404c858@2ndQuadrant.com
обсуждение исходный текст
Ответы Re: ALTER TABLE ADD COLUMN fast default  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Attached is a patch for $subject. It's based on Serge Reilau's patch of
about a year ago, taking into account comments made at the time. with
bitrot removed and other enhancements such as documentation.

Essentially it stores a value in pg_attribute that is used when the
stored tuple is missing the attribute. This works unless the default
expression is volatile, in which case a table rewrite is forced as
happens now.

Comments welcome.


cheers


andrew

-- 
Andrew Dunstan                https://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


Вложения

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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: [HACKERS] parallel.c oblivion of worker-startup failures
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: [HACKERS] Transaction control in procedures