diff options
| author | Patrick Cloke <clokep@users.noreply.github.com> | 2023-05-03 07:49:03 -0400 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2023-05-03 07:49:03 -0400 |
| commit | a7b3e9ce65335e452de216cb42b9e724e8f3ad1d (patch) | |
| tree | d7157fb842b4d8877a572d76522a6c998566af6a /changelog.d | |
| parent | Add config option to forget rooms automatically when users leave them (#15224) (diff) | |
| download | synapse-a7b3e9ce65335e452de216cb42b9e724e8f3ad1d.tar.xz | |
Set thread_id column to non-null for event_push_{actions,actions_staging,summary} (#15437)
Updates the database schema to require a thread_id (by adding a constraint that the column is non-null) for event_push_actions, event_push_actions_staging, and event_push_actions_summary. For PostgreSQL we add the constraint as NOT VALID, then VALIDATE the constraint a background job to avoid locking the table during an upgrade. For SQLite we simply rebuild the table & copy the data.
Diffstat (limited to 'changelog.d')
| -rw-r--r-- | changelog.d/15437.misc | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/changelog.d/15437.misc b/changelog.d/15437.misc new file mode 100644 index 0000000000..2dea23784f --- /dev/null +++ b/changelog.d/15437.misc @@ -0,0 +1 @@ +Make the `thread_id` column on `event_push_actions`, `event_push_actions_staging`, and `event_push_summary` non-null. |