pgsql: Install checks in executor startup to ensure that the tuples

Поиск
Список
Период
Сортировка
От tgl@postgresql.org (Tom Lane)
Тема pgsql: Install checks in executor startup to ensure that the tuples
Дата
Msg-id 20080808170119.0B569755315@cvs.postgresql.org
обсуждение исходный текст
Список pgsql-committers
Log Message:
-----------
Install checks in executor startup to ensure that the tuples produced by an
INSERT or UPDATE will match the target table's current rowtype.  In pre-8.3
releases inconsistency can arise with stale cached plans, as reported by
Merlin Moncure.  (We patched the equivalent hazard on the SELECT side in Feb
2007; I'm not sure why we thought there was no risk on the insertion side.)
In 8.3 and HEAD this problem should be impossible due to plan cache
invalidation management, but it seems prudent to make the check anyway.

Back-patch as far as 8.0.  7.x versions lack ALTER COLUMN TYPE, so there
seems no way to abuse a stale plan comparably.

Tags:
----
REL8_3_STABLE

Modified Files:
--------------
    pgsql/src/backend/executor:
        execMain.c (r1.303.2.1 -> r1.303.2.2)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/executor/execMain.c?r1=1.303.2.1&r2=1.303.2.2)

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

Предыдущее
От: dpage@pgfoundry.org (User Dpage)
Дата:
Сообщение: stackbuilder - wizard: Display the download progress dialogue in a
Следующее
От: tgl@postgresql.org (Tom Lane)
Дата:
Сообщение: pgsql: Install checks in executor startup to ensure that the tuples