Commit482e108

committed

Add test for REPLICA IDENTITY with a temporal key

You can only use REPLICA IDENTITY USING INDEX with a unique B-treeindex. This commit just adds a test showing that you cannot use itwith a WITHOUT OVERLAPS index (which is GiST).Author: Paul A. Jungwirth <pj@illuminatedcomputing.com>Discussion:https://www.postgresql.org/message-id/3775839b-3f0f-4c8a-ac03-a253222e6a4b%40illuminatedcomputing.com

1 parent84f08f2 commit482e108Copy full SHA for 482e108

File tree

-0

lines changed

-0

lines changed

Lines changed: 4 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -448,6 +448,10 @@ SELECT * FROM tp2 ORDER BY id, valid_at;`
`448`	`448`	`(1 row)`
`449`	`449`
`450`	`450`	`DROP TABLE temporal_partitioned;`
	`451`	`+-- ALTER TABLE REPLICA IDENTITY`
	`452`	`+-- (should fail)`
	`453`	`+ALTER TABLE temporal_rng REPLICA IDENTITY USING INDEX temporal_rng_pk;`
	`454`	`+ERROR: cannot use non-unique index "temporal_rng_pk" as replica identity`
`451`	`455`	`--`
`452`	`456`	`-- test FK dependencies`
`453`	`457`	`--`

Lines changed: 4 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -315,6 +315,10 @@ SELECT * FROM tp1 ORDER BY id, valid_at;`
`315`	`315`	`SELECT*FROM tp2ORDER BY id, valid_at;`
`316`	`316`	`DROPTABLE temporal_partitioned;`
`317`	`317`
	`318`	`+-- ALTER TABLE REPLICA IDENTITY`
	`319`	`+-- (should fail)`
	`320`	`+ALTERTABLE temporal_rng REPLICA IDENTITY USING INDEX temporal_rng_pk;`
	`321`	`+`
`318`	`322`	`--`
`319`	`323`	`-- test FK dependencies`
`320`	`324`	`--`

Comments

(0)