The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/15/sql-dropindex.html
Description:
I had to find out (as it is not in the given documentation) that to drop an
index for a table in a named schema (later "schemaname.tablename") you have
to prefix the schemaname for the index inte DROP statement.
Consider
CREATE INDEX indexname ON schemaname.tablename (<some columns>)
To drop it you will have to perform
DROP INDEX schemaname.indexname
(as I have read that indices are tied to schemas)
The following statement will fail (which was not clear from documentation)
DROP INDEX indexname