From 69afe3f7a0d89f3422ddbd3aa16bc9bbc01056eb Mon Sep 17 00:00:00 2001 From: reivilibre Date: Mon, 13 Nov 2023 16:03:22 +0000 Subject: Add a Postgres `REPLICA IDENTITY` to tables that do not have an implicit one. This should allow use of Postgres logical replication. (#16456) * Add Postgres replica identities to tables that don't have an implicit one Fixes #16224 * Newsfile Signed-off-by: Olivier Wilkinson (reivilibre) * Move the delta to version 83 as we missed the boat for 82 * Add a test that all tables have a REPLICA IDENTITY * Extend the test to include when indices are deleted * isort * black * Fully qualify `oid` as it is a 'hidden attribute' in Postgres 11 * Update tests/storage/test_database.py Co-authored-by: Patrick Cloke * Add missed tables --------- Signed-off-by: Olivier Wilkinson (reivilibre) Co-authored-by: Patrick Cloke --- changelog.d/16456.misc | 1 + 1 file changed, 1 insertion(+) create mode 100644 changelog.d/16456.misc (limited to 'changelog.d/16456.misc') diff --git a/changelog.d/16456.misc b/changelog.d/16456.misc new file mode 100644 index 0000000000..baee042f2f --- /dev/null +++ b/changelog.d/16456.misc @@ -0,0 +1 @@ +Add a Postgres `REPLICA IDENTITY` to tables that do not have an implicit one. This should allow use of Postgres logical replication. \ No newline at end of file -- cgit 1.5.1