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/executor/execUtils.c | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'src/backend/executor/execUtils.c') diff --git a/src/backend/executor/execUtils.c b/src/backend/executor/execUtils.c index 4aa3170daa6..c9c7ef79396 100644 --- a/src/backend/executor/execUtils.c +++ b/src/backend/executor/execUtils.c @@ -8,7 +8,7 @@ * * * IDENTIFICATION - * $Header: /cvsroot/pgsql/src/backend/executor/execUtils.c,v 1.104 2003/09/24 18:54:01 tgl Exp $ + * $Header: /cvsroot/pgsql/src/backend/executor/execUtils.c,v 1.105 2003/09/25 18:58:35 tgl Exp $ * *------------------------------------------------------------------------- */ @@ -178,6 +178,7 @@ CreateExecutorState(void) */ estate->es_direction = ForwardScanDirection; estate->es_snapshot = SnapshotNow; + estate->es_snapshot_cid = FirstCommandId; estate->es_range_table = NIL; estate->es_result_relations = NULL; -- cgit v1.2.3