# HG changeset patch
# User Kim Alvefur <zash@zash.se>
# Date 1744357504 -7200
# Node ID 2558be2daacaface5cc5d260d63033a7288407d7
# Parent  87dd8639f08f6c5a4cf85679c90611abf0ea0568
mod_storage_sql: Retrieve all indices to see if the new one exists

Otherwise it warns about it being missing, even if it exists.

diff -r 87dd8639f08f -r 2558be2daaca plugins/mod_storage_sql.lua
--- a/plugins/mod_storage_sql.lua	Thu Apr 10 16:07:32 2025 +0100
+++ b/plugins/mod_storage_sql.lua	Fri Apr 11 09:45:04 2025 +0200
@@ -883,7 +883,7 @@
 					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