Обсуждение: pgsql: Process withCheckOption exprs in setrefs.c

Поиск
Список
Период
Сортировка

pgsql: Process withCheckOption exprs in setrefs.c

От
Stephen Frost
Дата:
Process withCheckOption exprs in setrefs.c

While withCheckOption exprs had been handled in many cases by
happenstance, they need to be handled during set_plan_references and
more specifically down in set_plan_refs for ModifyTable plan nodes.
This is to ensure that the opfuncid's are set for operators referenced
in the withCheckOption exprs.

Identified as an issue by Thom Brown

Patch by Dean Rasheed

Back-patch to 9.4, where withCheckOption was introduced.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/6ef8c658af2127f4e62cb24feade8b465c9e2fea

Modified Files
--------------
src/backend/optimizer/plan/setrefs.c          |    3 +++
src/test/regress/expected/updatable_views.out |   20 ++++++++++++++++++++
src/test/regress/sql/updatable_views.sql      |   19 +++++++++++++++++++
3 files changed, 42 insertions(+)