| From: | Heikki Linnakangas <heikki(dot)linnakangas(at)iki(dot)fi> |
|---|---|
| To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
| Subject: | pgsql: Add test for row-locking and multixids with prepared transaction |
| Date: | 2026-03-04 09:42:46 |
| Message-ID: | E1vxikg-002KGU-1A@gemulon.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers |
Add test for row-locking and multixids with prepared transactions
This is a repro for the issue fixed in commit ccae90abdb. Backpatch to
v17 like that commit, although that's a little arbitrary as this test
would work on older versions too.
Author: Sami Imseih <samimseih(at)gmail(dot)com>
Discussion: https://www.postgresql.org/message-id/CAA5RZ0twq5bNMq0r0QNoopQnAEv+J3qJNCrLs7HVqTEntBhJ=g@mail.gmail.com
Backpatch-through: 17
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/fe08113aefc9dec62f218d5d712dde4ffbb0f0a3
Modified Files
--------------
src/test/regress/expected/prepared_xacts.out | 30 ++++++++++++++++++++++++++++
src/test/regress/sql/prepared_xacts.sql | 25 +++++++++++++++++++++++
2 files changed, 55 insertions(+)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Amit Kapila | 2026-03-04 10:33:30 | pgsql: Allow table exclusions in publications via EXCEPT TABLE. |
| Previous Message | Heikki Linnakangas | 2026-03-04 09:28:35 | pgsql: Skip prepared_xacts test if max_prepared_transactions < 2 |