pgsql: Fix assertions with RI triggers in heap_update and heap_delete.

From: Heikki Linnakangas <heikki(dot)linnakangas(at)iki(dot)fi>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Fix assertions with RI triggers in heap_update and heap_delete.
Date: 2023-11-28 10:38:20
Message-ID: E1r7vTv-007eBr-Qg@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Fix assertions with RI triggers in heap_update and heap_delete.

If the tuple being updated is not visible to the crosscheck snapshot,
we return TM_Updated but the assertions would not hold in that case.
Move them to before the cross-check.

Fixes bug #17893. Backpatch to all supported versions.

Author: Alexander Lakhin
Backpatch-through: 12
Discussion: https://www.postgresql.org/message-id/17893-35847009eec517b5%40postgresql.org

Branch
------
REL_15_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/2873fbfe0d6500a45a316d2d42414a432a96e9f1

Modified Files
--------------
src/backend/access/heap/heapam.c | 41 +++++++++++++++++------------
src/include/access/tableam.h | 4 +--
src/test/isolation/expected/fk-snapshot.out | 22 ++++++++++++++++
src/test/isolation/specs/fk-snapshot.spec | 17 +++++++++++-
4 files changed, 64 insertions(+), 20 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Michael Paquier 2023-11-28 10:44:37 pgsql: Remove more statements from stats.sql
Previous Message Dean Rasheed 2023-11-28 09:55:53 pgsql: psql: Add tab completion for view options.