Fix ALTER TABLE / REPLICA IDENTITY for temporal tables
Peter Eisentraut <peter@eisentraut.org>
Fix ALTER TABLE / REPLICA IDENTITY for temporal tables REPLICA IDENTITY USING INDEX did not accept a GiST index. This should be allowed when used as a temporal primary key. Author: Paul Jungwirth <pj@illuminatedcomputing.com> Discussion: https://www.postgresql.org/message-id/04579cbf-b134-45e1-8f2d-8c54c849c1ee@illuminatedcomputing.com
Files
| Path | Change | +/− |
|---|---|---|
| src/backend/commands/tablecmds.c | modified | +8 −3 |
| src/test/regress/expected/without_overlaps.out | modified | +18 −2 |
| src/test/regress/sql/without_overlaps.sql | modified | +2 −1 |
Discussion
- SQL:2011 application time 230 messages · 2021-06-30 → 2025-06-02