]> granicus.if.org Git - postgresql/commit
Fix interaction between materializing holdable cursors and firing
authorTom Lane <tgl@sss.pgh.pa.us>
Mon, 11 Apr 2005 19:51:16 +0000 (19:51 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Mon, 11 Apr 2005 19:51:16 +0000 (19:51 +0000)
commitc3294f1cbfe02293b4a7c6b2e58ca4c09a7e541f
treed4d422b08f15bce2b32867ae3cc8e722e08e9df2
parent0c400f1bbc3231ed75e11d3ab0ec7a4a9d3c8486
Fix interaction between materializing holdable cursors and firing
deferred triggers: either one can create more work for the other,
so we have to loop till it's all gone.  Per example from andrew@supernews.
Add a regression test to help spot trouble in this area in future.
src/backend/access/transam/xact.c
src/backend/commands/trigger.c
src/backend/utils/mmgr/portalmem.c
src/include/commands/trigger.h
src/include/utils/portal.h
src/test/regress/expected/portals.out
src/test/regress/sql/portals.sql