]> 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:32 +0000 (19:51 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Mon, 11 Apr 2005 19:51:32 +0000 (19:51 +0000)
commitfa57fd1c0a4b9dee0bbd932c20d773d56a88a78f
tree0be076c1a21005086da1bda3b958f7c46af29f82
parentadd2c3f4d6b137b35c097354438779aacde2f1d9
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