pgsql: Fix SQL function execution to be safe with long-lived FmgrInfos.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема pgsql: Fix SQL function execution to be safe with long-lived FmgrInfos.
Дата
Msg-id E1UCHZu-0002Tx-Ue@gemulon.postgresql.org
обсуждение исходный текст
Список pgsql-committers
Fix SQL function execution to be safe with long-lived FmgrInfos.

fmgr_sql had been designed on the assumption that the FmgrInfo it's called
with has only query lifespan.  This is demonstrably unsafe in connection
with range types, as shown in bug #7881 from Andrew Gierth.  Fix things
so that we re-generate the function's cache data if the (sub)transaction
it was made in is no longer active.

Back-patch to 9.2.  This might be needed further back, but it's not clear
whether the case can realistically arise without range types, so for now
I'll desist from back-patching further.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/2b78d101d1d6b1d8533a7b7aeff4d82b10a915f8

Modified Files
--------------
src/backend/access/transam/xact.c |   21 +++++++++
src/backend/executor/functions.c  |   88 ++++++++++++++++++++++++++++++++-----
src/include/access/xact.h         |    1 +
3 files changed, 98 insertions(+), 12 deletions(-)


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: pgsql: Fix SQL function execution to be safe with long-lived FmgrInfos.
Следующее
От: Tom Lane
Дата:
Сообщение: pgsql: Get rid of any toast table when converting a table to a view.