From 55d85f42a891a812a9bbd69ebe530651a2f31624 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Wed, 1 Oct 2003 21:30:53 +0000 Subject: Repair RI trigger visibility problems (this time for sure ;-)) per recent discussion on pgsql-hackers: in READ COMMITTED mode we just have to force a QuerySnapshot update in the trigger, but in SERIALIZABLE mode we have to run the scan under a current snapshot and then complain if any rows would be updated/deleted that are not visible in the transaction snapshot. --- src/backend/commands/async.c | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'src/backend/commands/async.c') diff --git a/src/backend/commands/async.c b/src/backend/commands/async.c index 95c83c2372e..d977995f5ff 100644 --- a/src/backend/commands/async.c +++ b/src/backend/commands/async.c @@ -7,7 +7,7 @@ * Portions Copyright (c) 1994, Regents of the University of California * * IDENTIFICATION - * $Header: /cvsroot/pgsql/src/backend/commands/async.c,v 1.100 2003/09/15 23:33:39 tgl Exp $ + * $Header: /cvsroot/pgsql/src/backend/commands/async.c,v 1.101 2003/10/01 21:30:52 tgl Exp $ * *------------------------------------------------------------------------- */ @@ -537,7 +537,7 @@ AtCommit_Notify(void) */ result = heap_update(lRel, &lTuple->t_self, rTuple, &ctid, - GetCurrentCommandId(), + GetCurrentCommandId(), SnapshotAny, false /* no wait for commit */); switch (result) { -- cgit v1.2.3