diff options
author | reivilibre <oliverw@matrix.org> | 2023-11-13 16:03:22 +0000 |
---|---|---|
committer | GitHub <noreply@github.com> | 2023-11-13 16:03:22 +0000 |
commit | 69afe3f7a0d89f3422ddbd3aa16bc9bbc01056eb (patch) | |
tree | d6566d760c55a06560cd1af71fcb66a7d88e2707 /changelog.d | |
parent | Fix outbound_federation_restricted_to docs & note when added (#16628) (diff) | |
download | synapse-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')
-rw-r--r-- | changelog.d/16456.misc | 1 |
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 |