DROP INDEX - dropping index of a table in a named schema

Поиск
Список
Период
Сортировка
От PG Doc comments form
Тема DROP INDEX - dropping index of a table in a named schema
Дата
Msg-id 168476300238.719.4154059913239447201@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: DROP INDEX - dropping index of a table in a named schema  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-docs
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

В списке pgsql-docs по дате отправления:

Предыдущее
От: PG Doc comments form
Дата:
Сообщение: Incorrect/confusing information about timetz
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: DROP INDEX - dropping index of a table in a named schema