summary refs log tree commit diff
path: root/synapse/storage/schema/common
diff options
context:
space:
mode:
authorDavid Robertson <davidr@element.io>2023-12-05 16:07:42 +0000
committerDavid Robertson <davidr@element.io>2023-12-05 16:10:48 +0000
commit44377f5ac05ff4e95f440f5704805b87a37e3327 (patch)
tree4bceb3f51cf2ea6ad9420b4ff1457384ef0724fc /synapse/storage/schema/common
parentAmend changelog typo (diff)
downloadsynapse-44377f5ac05ff4e95f440f5704805b87a37e3327.tar.xz
Revert postgres logical replication deltaas v1.98.0rc1
This reverts two commits:

    0bb8e418a41c6f583ca9d705b400e37e2308a534
    "Fix postgres schema after dropping old tables (#16730)"

and

    51e4e35653f98c3f61222fbdbdb1dcb8864f7fca
    "Add a Postgres `REPLICA IDENTITY` to tables that do not have an implicit one. This should allow use of Postgres logical replication. (take  2, now with no added deadlocks!) (#16658)"

and also amends the changelog.
Diffstat (limited to 'synapse/storage/schema/common')
-rw-r--r--synapse/storage/schema/common/delta/83/10_replica_identity_applied_module_schemas.sql.postgres1
-rw-r--r--synapse/storage/schema/common/delta/83/10_replica_identity_applied_schema_deltas.sql.postgres1
-rw-r--r--synapse/storage/schema/common/delta/83/10_replica_identity_background_updates.sql.postgres1
-rw-r--r--synapse/storage/schema/common/delta/83/10_replica_identity_schema_compat_version.sql.postgres1
-rw-r--r--synapse/storage/schema/common/delta/83/10_replica_identity_schema_version.sql.postgres1
5 files changed, 0 insertions, 5 deletions
diff --git a/synapse/storage/schema/common/delta/83/10_replica_identity_applied_module_schemas.sql.postgres b/synapse/storage/schema/common/delta/83/10_replica_identity_applied_module_schemas.sql.postgres
deleted file mode 100644
index 57c35b6430..0000000000
--- a/synapse/storage/schema/common/delta/83/10_replica_identity_applied_module_schemas.sql.postgres
+++ /dev/null
@@ -1 +0,0 @@
-ALTER TABLE applied_module_schemas REPLICA IDENTITY USING INDEX applied_module_schemas_module_name_file_key;
diff --git a/synapse/storage/schema/common/delta/83/10_replica_identity_applied_schema_deltas.sql.postgres b/synapse/storage/schema/common/delta/83/10_replica_identity_applied_schema_deltas.sql.postgres
deleted file mode 100644
index 1426f9a9e4..0000000000
--- a/synapse/storage/schema/common/delta/83/10_replica_identity_applied_schema_deltas.sql.postgres
+++ /dev/null
@@ -1 +0,0 @@
-ALTER TABLE applied_schema_deltas REPLICA IDENTITY USING INDEX applied_schema_deltas_version_file_key;
diff --git a/synapse/storage/schema/common/delta/83/10_replica_identity_background_updates.sql.postgres b/synapse/storage/schema/common/delta/83/10_replica_identity_background_updates.sql.postgres
deleted file mode 100644
index f04937b3db..0000000000
--- a/synapse/storage/schema/common/delta/83/10_replica_identity_background_updates.sql.postgres
+++ /dev/null
@@ -1 +0,0 @@
-ALTER TABLE background_updates REPLICA IDENTITY USING INDEX background_updates_uniqueness;
diff --git a/synapse/storage/schema/common/delta/83/10_replica_identity_schema_compat_version.sql.postgres b/synapse/storage/schema/common/delta/83/10_replica_identity_schema_compat_version.sql.postgres
deleted file mode 100644
index e3a6f7ca4f..0000000000
--- a/synapse/storage/schema/common/delta/83/10_replica_identity_schema_compat_version.sql.postgres
+++ /dev/null
@@ -1 +0,0 @@
-ALTER TABLE schema_compat_version REPLICA IDENTITY USING INDEX schema_compat_version_lock_key;
diff --git a/synapse/storage/schema/common/delta/83/10_replica_identity_schema_version.sql.postgres b/synapse/storage/schema/common/delta/83/10_replica_identity_schema_version.sql.postgres
deleted file mode 100644
index c10efe0563..0000000000
--- a/synapse/storage/schema/common/delta/83/10_replica_identity_schema_version.sql.postgres
+++ /dev/null
@@ -1 +0,0 @@
-ALTER TABLE schema_version REPLICA IDENTITY USING INDEX schema_version_lock_key;