Re: DROP INDEX - dropping index of a table in a named schema - Mailing list pgsql-docs

From David G. Johnston
Subject Re: DROP INDEX - dropping index of a table in a named schema
Date
Msg-id CAKFQuwa=X0bQbPKwMC0HL8Ka+9vSQec-Q8QcgoX=U2BevpxP=w@mail.gmail.com
Whole thread Raw
In response to DROP INDEX - dropping index of a table in a named schema  (PG Doc comments form <noreply@postgresql.org>)
List pgsql-docs
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.
 

pgsql-docs by date:

Previous
From: PG Doc comments form
Date:
Subject: DROP INDEX - dropping index of a table in a named schema
Next
From: PG Doc comments form
Date:
Subject: Typo