prosody
706f7d1affc2
plugins/mod_storage_sql.lua

Find changesets by keywords by author, files, the commit message, revision number or hash, or revset expression.

Software / code / prosody

Diff

plugins/mod_storage_sql.lua @ 13159:706f7d1affc2

mod_storage_sql: Fix column name in index check for PostgreSQL Forgot to change the column name in 9a7523ea45cb
author Kim Alvefur <zash@zash.se>
date Sat, 17 Jun 2023 13:37:33 +0200
parent 13158:cf2a907ac130
child 13190:9dc6de46dae3
line wrap: on
line diff
--- a/plugins/mod_storage_sql.lua	Sat Jun 17 13:36:42 2023 +0200
+++ b/plugins/mod_storage_sql.lua	Sat Jun 17 13:37:33 2023 +0200
@@ -854,7 +854,7 @@
 						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