aboutsummaryrefslogtreecommitdiff
path: root/contrib/postgres_fdw/postgres_fdw.c
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2014-12-11 19:37:07 -0500
committerTom Lane <tgl@sss.pgh.pa.us>2014-12-11 19:37:07 -0500
commitf14196c3597364f3562e65bf869f7942fc9188b4 (patch)
tree27994e622b2d621e07ab5680078aa4d16d25e9f5 /contrib/postgres_fdw/postgres_fdw.c
parent2c96b0ba8dc90b5a5f9f787b1acbc0ff27b1778f (diff)
downloadpostgresql-f14196c3597364f3562e65bf869f7942fc9188b4.tar.gz
postgresql-f14196c3597364f3562e65bf869f7942fc9188b4.zip
Fix corner case where SELECT FOR UPDATE could return a row twice.
In READ COMMITTED mode, if a SELECT FOR UPDATE discovers it has to redo WHERE-clause checking on rows that have been updated since the SELECT's snapshot, it invokes EvalPlanQual processing to do that. If this first occurs within a non-first child table of an inheritance tree, the previous coding could accidentally re-return a matching row from an earlier, already-scanned child table. (And, to add insult to injury, I think this could make it miss returning a row that should have been returned, if the updated row that this happens on should still have passed the WHERE qual.) Per report from Kyotaro Horiguchi; the added isolation test is based on his test case. This has been broken for quite awhile, so back-patch to all supported branches.
Diffstat (limited to 'contrib/postgres_fdw/postgres_fdw.c')
0 files changed, 0 insertions, 0 deletions