| From: | Peter Eisentraut <peter(at)eisentraut(dot)org> |
|---|---|
| To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
| Subject: | pgsql: Add test for REPLICA IDENTITY with a temporal key |
| Date: | 2024-05-08 13:40:50 |
| Message-ID: | E1s4hXN-0001VC-ED@gemulon.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers |
Add test for REPLICA IDENTITY with a temporal key
You can only use REPLICA IDENTITY USING INDEX with a unique B-tree
index. This commit just adds a test showing that you cannot use it
with a WITHOUT OVERLAPS index (which is GiST).
Author: Paul A. Jungwirth <pj(at)illuminatedcomputing(dot)com>
Discussion: https://www.postgresql.org/message-id/3775839b-3f0f-4c8a-ac03-a253222e6a4b%40illuminatedcomputing.com
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/482e108cd38db5366c52a6b1f4180f34c1796155
Modified Files
--------------
src/test/regress/expected/without_overlaps.out | 4 ++++
src/test/regress/sql/without_overlaps.sql | 4 ++++
2 files changed, 8 insertions(+)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2024-05-08 15:13:47 | pgsql: Doc: document that triggers can break referential integrity. |
| Previous Message | Peter Eisentraut | 2024-05-08 08:23:28 | pgsql: doc: Improve order of options on pg_upgrade reference page |