diff options
| author | Kim Alvefur <zash@zash.se> | 2023-06-17 13:37:33 +0200 |
|---|---|---|
| committer | Kim Alvefur <zash@zash.se> | 2023-06-17 13:37:33 +0200 |
| commit | 9f0a28f1c498a20c51af4686a5ecc9ff1b7c852c (patch) | |
| tree | 2e457e894f1a988d7190b8547dc641c2f9bc383a /plugins | |
| parent | 935f28230ac894956d6933a951236997d7e23f30 (diff) | |
| download | prosody-9f0a28f1c498a20c51af4686a5ecc9ff1b7c852c.tar.gz prosody-9f0a28f1c498a20c51af4686a5ecc9ff1b7c852c.zip | |
mod_storage_sql: Fix column name in index check for PostgreSQL
Forgot to change the column name in 9a7523ea45cb
Diffstat (limited to 'plugins')
| -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 04022f2a..f348b1aa 100644 --- a/plugins/mod_storage_sql.lua +++ b/plugins/mod_storage_sql.lua @@ -854,7 +854,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 "relname" FROM "pg_indexes" WHERE "tablename"='prosody' AND "indexname"='prosody_index';]] do + for row in engine:select [[SELECT "indexname" FROM "pg_indexes" WHERE "tablename"='prosody' AND "indexname"='prosody_index';]] do indices[row[1]] = true; end end |