0003-Revert-Add-test-for-REPLICA-IDENTITY-with-a-temporal.patch
text/plain
Filename: 0003-Revert-Add-test-for-REPLICA-IDENTITY-with-a-temporal.patch
Type: text/plain
Part: 2
Message:
Re: SQL:2011 application time
Patch
Same data as JSON:
GET /api/v1/attachments/:id/patch
the parsed metadata as JSON — format, series position, per-file stats; never the diff bytes.
API reference →
Format: format-patch
Series: patch 0003
Subject: Revert "Add test for REPLICA IDENTITY with a temporal key"
| File | + | − |
|---|---|---|
| src/test/regress/expected/without_overlaps.out | 0 | 4 |
| src/test/regress/sql/without_overlaps.sql | 0 | 4 |
From 6cd84161e8caa0af96b61df84a5ab2128f531f03 Mon Sep 17 00:00:00 2001
From: Peter Eisentraut <peter@eisentraut.org>
Date: Wed, 15 May 2024 10:28:31 +0200
Subject: [PATCH 03/10] Revert "Add test for REPLICA IDENTITY with a temporal
key"
This reverts commit 482e108cd38db5366c52a6b1f4180f34c1796155.
---
src/test/regress/expected/without_overlaps.out | 4 ----
src/test/regress/sql/without_overlaps.sql | 4 ----
2 files changed, 8 deletions(-)
diff --git a/src/test/regress/expected/without_overlaps.out b/src/test/regress/expected/without_overlaps.out
index abc22d0113f..f6fe8f09369 100644
--- a/src/test/regress/expected/without_overlaps.out
+++ b/src/test/regress/expected/without_overlaps.out
@@ -448,10 +448,6 @@ SELECT * FROM tp2 ORDER BY id, valid_at;
(1 row)
DROP TABLE temporal_partitioned;
--- ALTER TABLE REPLICA IDENTITY
--- (should fail)
-ALTER TABLE temporal_rng REPLICA IDENTITY USING INDEX temporal_rng_pk;
-ERROR: cannot use non-unique index "temporal_rng_pk" as replica identity
--
-- test FK dependencies
--
diff --git a/src/test/regress/sql/without_overlaps.sql b/src/test/regress/sql/without_overlaps.sql
index d4ae03ae529..da2b7f19a85 100644
--- a/src/test/regress/sql/without_overlaps.sql
+++ b/src/test/regress/sql/without_overlaps.sql
@@ -315,10 +315,6 @@ CREATE TABLE tp2 PARTITION OF temporal_partitioned FOR VALUES IN ('[3,4)', '[4,5
SELECT * FROM tp2 ORDER BY id, valid_at;
DROP TABLE temporal_partitioned;
--- ALTER TABLE REPLICA IDENTITY
--- (should fail)
-ALTER TABLE temporal_rng REPLICA IDENTITY USING INDEX temporal_rng_pk;
-
--
-- test FK dependencies
--
--
2.44.0