summary refs log tree commit diff
path: root/synapse/storage/schema/main
diff options
context:
space:
mode:
authorDavid Robertson <davidr@element.io>2023-12-05 11:08:40 +0000
committerGitHub <noreply@github.com>2023-12-05 11:08:40 +0000
commit0bb8e418a41c6f583ca9d705b400e37e2308a534 (patch)
tree694c9cf285618594aed701470f69a8c71845460c /synapse/storage/schema/main
parentAdd a Postgres `REPLICA IDENTITY` to tables that do not have an implicit one.... (diff)
downloadsynapse-0bb8e418a41c6f583ca9d705b400e37e2308a534.tar.xz
Fix postgres schema after dropping old tables (#16730)
Diffstat (limited to 'synapse/storage/schema/main')
-rw-r--r--synapse/storage/schema/main/delta/83/10_replica_identity_batch_events.sql.postgres1
-rw-r--r--synapse/storage/schema/main/delta/83/10_replica_identity_event_txn_id.sql.postgres1
-rw-r--r--synapse/storage/schema/main/delta/83/10_replica_identity_insertion_event_edges.sql.postgres1
-rw-r--r--synapse/storage/schema/main/delta/83/10_replica_identity_insertion_event_extremities.sql.postgres1
-rw-r--r--synapse/storage/schema/main/delta/83/10_replica_identity_insertion_events.sql.postgres1
5 files changed, 0 insertions, 5 deletions
diff --git a/synapse/storage/schema/main/delta/83/10_replica_identity_batch_events.sql.postgres b/synapse/storage/schema/main/delta/83/10_replica_identity_batch_events.sql.postgres
deleted file mode 100644
index cd4471f4d7..0000000000
--- a/synapse/storage/schema/main/delta/83/10_replica_identity_batch_events.sql.postgres
+++ /dev/null
@@ -1 +0,0 @@
-ALTER TABLE batch_events REPLICA IDENTITY USING INDEX chunk_events_event_id;
diff --git a/synapse/storage/schema/main/delta/83/10_replica_identity_event_txn_id.sql.postgres b/synapse/storage/schema/main/delta/83/10_replica_identity_event_txn_id.sql.postgres
deleted file mode 100644
index a2bacbc96d..0000000000
--- a/synapse/storage/schema/main/delta/83/10_replica_identity_event_txn_id.sql.postgres
+++ /dev/null
@@ -1 +0,0 @@
-ALTER TABLE event_txn_id REPLICA IDENTITY USING INDEX event_txn_id_event_id;
diff --git a/synapse/storage/schema/main/delta/83/10_replica_identity_insertion_event_edges.sql.postgres b/synapse/storage/schema/main/delta/83/10_replica_identity_insertion_event_edges.sql.postgres
deleted file mode 100644
index 8322722b1a..0000000000
--- a/synapse/storage/schema/main/delta/83/10_replica_identity_insertion_event_edges.sql.postgres
+++ /dev/null
@@ -1 +0,0 @@
-ALTER TABLE insertion_event_edges REPLICA IDENTITY FULL;
diff --git a/synapse/storage/schema/main/delta/83/10_replica_identity_insertion_event_extremities.sql.postgres b/synapse/storage/schema/main/delta/83/10_replica_identity_insertion_event_extremities.sql.postgres
deleted file mode 100644
index 1816ce5a49..0000000000
--- a/synapse/storage/schema/main/delta/83/10_replica_identity_insertion_event_extremities.sql.postgres
+++ /dev/null
@@ -1 +0,0 @@
-ALTER TABLE insertion_event_extremities REPLICA IDENTITY USING INDEX insertion_event_extremities_event_id;
diff --git a/synapse/storage/schema/main/delta/83/10_replica_identity_insertion_events.sql.postgres b/synapse/storage/schema/main/delta/83/10_replica_identity_insertion_events.sql.postgres
deleted file mode 100644
index 1fdbd597c7..0000000000
--- a/synapse/storage/schema/main/delta/83/10_replica_identity_insertion_events.sql.postgres
+++ /dev/null
@@ -1 +0,0 @@
-ALTER TABLE insertion_events REPLICA IDENTITY USING INDEX insertion_events_event_id;