Обсуждение: DROP INDEX - dropping index of a table in a named schema
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
On Monday, May 22, 2023, PG Doc comments form <noreply@postgresql.org> wrote:
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.
The create index docs say that an index for a table always exists within the same schema as that table. If that schema isn’t in your search_path then it follows you need to schema qualify references to it.
David J.