summary refs log tree commit diff
path: root/changelog.d/16456.misc
diff options
context:
space:
mode:
authorreivilibre <oliverw@matrix.org>2023-11-13 16:03:22 +0000
committerGitHub <noreply@github.com>2023-11-13 16:03:22 +0000
commit69afe3f7a0d89f3422ddbd3aa16bc9bbc01056eb (patch)
treed6566d760c55a06560cd1af71fcb66a7d88e2707 /changelog.d/16456.misc
parentFix outbound_federation_restricted_to docs & note when added (#16628) (diff)
downloadsynapse-69afe3f7a0d89f3422ddbd3aa16bc9bbc01056eb.tar.xz
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) <oliverw@matrix.org>

* 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 <clokep@users.noreply.github.com>

* Add missed tables

---------

Signed-off-by: Olivier Wilkinson (reivilibre) <oliverw@matrix.org>
Co-authored-by: Patrick Cloke <clokep@users.noreply.github.com>
Diffstat (limited to 'changelog.d/16456.misc')
-rw-r--r--changelog.d/16456.misc1
1 files changed, 1 insertions, 0 deletions
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