aboutsummaryrefslogtreecommitdiff
path: root/src/backend/commands/async.c
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2003-10-01 21:30:53 +0000
committerTom Lane <tgl@sss.pgh.pa.us>2003-10-01 21:30:53 +0000
commit55d85f42a891a812a9bbd69ebe530651a2f31624 (patch)
treecc2cb842242c7f683b73f6ac297a9939eb031976 /src/backend/commands/async.c
parent6099bc03f34b02fd5cf99f4187c9c6c189cd3c66 (diff)
downloadpostgresql-55d85f42a891a812a9bbd69ebe530651a2f31624.tar.gz
postgresql-55d85f42a891a812a9bbd69ebe530651a2f31624.zip
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.
Diffstat (limited to 'src/backend/commands/async.c')
-rw-r--r--src/backend/commands/async.c4
1 files changed, 2 insertions, 2 deletions
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)
{