pgsql: Fill tuple before HeapSatisfiesHOTAndKeyUpdate

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема pgsql: Fill tuple before HeapSatisfiesHOTAndKeyUpdate
Дата
Msg-id E1U1H0E-0007Cs-A9@gemulon.postgresql.org
обсуждение исходный текст
Ответы Re: pgsql: Fill tuple before HeapSatisfiesHOTAndKeyUpdate  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-committers
Fill tuple before HeapSatisfiesHOTAndKeyUpdate

Failing to do this results in almost all updates to system catalogs
being non-HOT updates, because the OID column would differ (not having
been set for the new tuple), which is an indexed column.

While at it, make sure to set the tableoid early in both old and new
tuples as well.  This isn't of much consequence, since that column is
seldom (never?) indexed.

Report and patch from Andres Freund.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/9ee00ef4c7de991b9371f614ce9c03ff436ce383

Modified Files
--------------
src/backend/access/heap/heapam.c |   39 +++++++++++++++++++++++--------------
1 files changed, 24 insertions(+), 15 deletions(-)


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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: pgsql: Add CREATE RECURSIVE VIEW syntax
Следующее
От: Alvaro Herrera
Дата:
Сообщение: pgsql: Fix typo in freeze_table_age implementation