]> granicus.if.org Git - postgresql/commit
Fix mishandling of after-trigger state when a SQL function returns multiple
authorTom Lane <tgl@sss.pgh.pa.us>
Thu, 12 Oct 2006 17:02:24 +0000 (17:02 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Thu, 12 Oct 2006 17:02:24 +0000 (17:02 +0000)
commitd2e17e1ddc3d09478575b18ce00876d8668011b3
tree8b0cbfef22b15cd39f874cedb5c1f05e6a24ab39
parentb38900c7677657a815e75781b776fb1e41054df3
Fix mishandling of after-trigger state when a SQL function returns multiple
rows --- if the surrounding query queued any trigger events between the rows,
the events would be fired at the wrong time, leading to bizarre behavior.
Per report from Merlin Moncure.

This is a simple patch that should solve the problem fully in the back
branches, but in HEAD we also need to consider the possibility of queries
with RETURNING clauses.  Will look into a fix for that separately.
src/backend/executor/functions.c