diff options
author | Tom Lane <tgl@sss.pgh.pa.us> | 2003-10-01 21:30:53 +0000 |
---|---|---|
committer | Tom Lane <tgl@sss.pgh.pa.us> | 2003-10-01 21:30:53 +0000 |
commit | 55d85f42a891a812a9bbd69ebe530651a2f31624 (patch) | |
tree | cc2cb842242c7f683b73f6ac297a9939eb031976 /src/backend/commands/async.c | |
parent | 6099bc03f34b02fd5cf99f4187c9c6c189cd3c66 (diff) | |
download | postgresql-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.c | 4 |
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) { |