Re: DROP INDEX - dropping index of a table in a named schema
On Monday, May 22, 2023, PG Doc comments form 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.
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 () 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