From c63a5452d8a44e087cfb5bf843e7bd555c400b04 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Thu, 25 Sep 2003 18:58:36 +0000 Subject: Get rid of ReferentialIntegritySnapshotOverride by extending Executor API to allow es_snapshot to be set to SnapshotNow rather than a query snapshot. This solves a bug reported by Wade Klaver, wherein triggers fired as a result of RI cascade updates could misbehave. --- src/backend/commands/trigger.c | 8 +------- 1 file changed, 1 insertion(+), 7 deletions(-) (limited to 'src/backend/commands/trigger.c') diff --git a/src/backend/commands/trigger.c b/src/backend/commands/trigger.c index d6868818656..5a824ce40ee 100644 --- a/src/backend/commands/trigger.c +++ b/src/backend/commands/trigger.c @@ -7,7 +7,7 @@ * Portions Copyright (c) 1994, Regents of the University of California * * IDENTIFICATION - * $Header: /cvsroot/pgsql/src/backend/commands/trigger.c,v 1.157 2003/09/25 06:57:58 petere Exp $ + * $Header: /cvsroot/pgsql/src/backend/commands/trigger.c,v 1.158 2003/09/25 18:58:35 tgl Exp $ * *------------------------------------------------------------------------- */ @@ -1862,12 +1862,6 @@ DeferredTriggerExecute(DeferredTriggerEvent event, int itemno, if (rettuple != NULL && rettuple != &oldtuple && rettuple != &newtuple) heap_freetuple(rettuple); - /* - * Might have been a referential integrity constraint trigger. Reset - * the snapshot overriding flag. - */ - ReferentialIntegritySnapshotOverride = false; - /* * Release buffers */ -- cgit v1.2.3