diff options
| author | Kim Alvefur <zash@zash.se> | 2025-04-11 09:45:04 +0200 |
|---|---|---|
| committer | Kim Alvefur <zash@zash.se> | 2025-04-11 09:45:04 +0200 |
| commit | 7340c4e1f264712771933cb8455511fc09cda442 (patch) | |
| tree | 489ba519046a4b5f34ede444f2ae308afbbe4be7 | |
| parent | aa37a7085004b0b114c8e3c22447cfb826555562 (diff) | |
| download | prosody-7340c4e1f264712771933cb8455511fc09cda442.tar.gz prosody-7340c4e1f264712771933cb8455511fc09cda442.zip | |
mod_storage_sql: Retrieve all indices to see if the new one exists
Otherwise it warns about it being missing, even if it exists.
| -rw-r--r-- | plugins/mod_storage_sql.lua | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/plugins/mod_storage_sql.lua b/plugins/mod_storage_sql.lua index e7b06f31..6d9af68a 100644 --- a/plugins/mod_storage_sql.lua +++ b/plugins/mod_storage_sql.lua @@ -883,7 +883,7 @@ local function upgrade_table(engine, params, apply_changes) -- luacheck: ignore indices[row[1]] = true; end elseif params.driver == "PostgreSQL" then - for row in engine:select [[SELECT "indexname" FROM "pg_indexes" WHERE "tablename"='prosody' AND "indexname"='prosody_index';]] do + for row in engine:select [[SELECT "indexname" FROM "pg_indexes" WHERE "tablename"='prosody';]] do indices[row[1]] = true; end end |