aboutsummaryrefslogtreecommitdiff
path: root/contrib/jsonb_plpython/jsonb_plpython3u.control
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2019-04-06 15:09:09 -0400
committerTom Lane <tgl@sss.pgh.pa.us>2019-04-06 15:09:09 -0400
commit46e3442c9ec858071d60a1c0fae2e9868aeaa0c8 (patch)
treec7554b37812cb25fb26e9c8e4f7a4fb70831fa3c /contrib/jsonb_plpython/jsonb_plpython3u.control
parent249d64999615802752940e017ee5166e726bc7cd (diff)
downloadpostgresql-46e3442c9ec858071d60a1c0fae2e9868aeaa0c8.tar.gz
postgresql-46e3442c9ec858071d60a1c0fae2e9868aeaa0c8.zip
Fix failures in validateForeignKeyConstraint's slow path.
The foreign-key-checking loop in ATRewriteTables failed to ignore relations without storage (e.g., partitioned tables), unlike the initial loop. This accidentally worked as long as RI_Initial_Check succeeded, which it does in most practical cases (including all the ones exercised in the existing regression tests :-(). However, if that failed, as for instance when there are permissions issues, then we entered the slow fire-the-trigger-on-each-tuple path. And that would try to read from the referencing relation, and fail if it lacks storage. A second problem, recently introduced in HEAD, was that this loop had been broken by sloppy refactoring for the tableam API changes. Repair both issues, and add a regression test case so we have some coverage on this code path. Back-patch as needed to v11. (It looks like this code could do with additional bulletproofing, but let's get a working test case in place first.) Hadi Moshayedi, Tom Lane, Andres Freund Discussion: https://postgr.es/m/CAK=1=WrnNmBbe5D9sm3t0a6dnAq3cdbF1vXY816j1wsMqzC8bw@mail.gmail.com Discussion: https://postgr.es/m/19030.1554574075@sss.pgh.pa.us Discussion: https://postgr.es/m/20190325180405.jytoehuzkeozggxx%40alap3.anarazel.de
Diffstat (limited to 'contrib/jsonb_plpython/jsonb_plpython3u.control')
0 files changed, 0 insertions, 0 deletions