search

matrix-org / synapse

Synapse: Matrix homeserver written in Python/Twisted.
https://matrix-org.github.io/synapse
Apache License 2.0
11.83k stars 2.13k forks source link

Add a Postgres `REPLICA IDENTITY` to tables that do not have an implicit one. This should allow use of Postgres logical replication. #16456

Closed reivilibre closed 11 months ago

reivilibre commented 1 year ago

Fixes: #16224

Base: develop

Original commit schedule, with full messages:

  1. Add Postgres replica identities to tables that don't have an implicit one \ Fixes #16224
clokep commented 11 months ago

Although looks like your new test is failing?

reivilibre commented 11 months ago

Although looks like your new test is failing?

oid is a 'hidden attribute' in Postgres 11 (but not 12+) which means you have to be very explicit about selecting it, it turns out.