pgsql: Add test for REPLICA IDENTITY with a temporal key

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема pgsql: Add test for REPLICA IDENTITY with a temporal key
Дата
Msg-id E1s4hXN-0001VC-ED@gemulon.postgresql.org
обсуждение исходный текст
Список 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@illuminatedcomputing.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(+)


В списке pgsql-committers по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: pgsql: doc: Improve order of options on pg_upgrade reference page
Следующее
От: Tom Lane
Дата:
Сообщение: pgsql: Doc: document that triggers can break referential integrity.