Comparison

mod_storage_sql: Improve check for old table index on PostgreSQL The "pg_indexes" view is much simpler to inspect than "pg_class"

comparison

equal deleted inserted replaced

-:6cf5c215825d
+:9a7523ea45cb
 				if params.driver == "SQLite3" then
 					for row in engine:select [[SELECT "name" from "sqlite_schema" WHERE "name"='prosody_index';]] do
 						indices[row[1]] = true;
 					end
 				elseif params.driver == "PostgreSQL" then
-					for row in engine:select [[SELECT "relname" FROM "pg_class" WHERE "relname"='prosody_index';]] do
+					for row in engine:select [[SELECT "relname" FROM "pg_indexes" WHERE "tablename"='prosody' AND "indexname"='prosody_index';]] do
 						indices[row[1]] = true;
 					end
 				end
 			end)
 			if apply_changes then