git.postgresql.org Git - postgresql.git/commit

git projects / postgresql.git / commit

Fix trigger WHEN conditions when both BEFORE and AFTER triggers exist.

author Tom Lane <tgl@sss.pgh.pa.us>

2011年8月21日 22:15:55 +0000 (18:15 -0400)

committer Tom Lane <tgl@sss.pgh.pa.us>

2011年8月21日 22:15:55 +0000 (18:15 -0400)

commit b33f78df17c32364d51f6e5128f8d81d7d3013a2

tree d5acbc5668d0f60aa8befbb1ae42f807c447df6c tree

parent 6cc08e703bb078ee1e8d183caf4596d62bf12bf7 commit | diff

Fix trigger WHEN conditions when both BEFORE and AFTER triggers exist.

Due to tuple-slot mismanagement, evaluation of WHEN conditions for AFTER
ROW UPDATE triggers could crash if there had been a BEFORE ROW trigger
fired for the same update. Fix by not trying to overload the use of
estate->es_trig_tuple_slot. Per report from Yoran Heling.

Back-patch to 9.0, when trigger WHEN conditions were introduced.

src/backend/commands/trigger.c diff | blob | blame | history

src/backend/executor/execMain.c diff | blob | blame | history

src/backend/executor/execUtils.c diff | blob | blame | history

src/include/nodes/execnodes.h diff | blob | blame | history

src/test/regress/expected/triggers.out diff | blob | blame | history

src/test/regress/sql/triggers.sql diff | blob | blame | history

This is the main PostgreSQL git repository.

RSS Atom