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
Дата
в 13:43:22
Msg-id
168476300238.719.4154059913239447201@wrigleys.postgresql.org
Список
Дерево обсуждения
DROP INDEX - dropping index of a table in a named schema PG Doc comments form <noreply@postgresql.org>
Re: DROP INDEX - dropping index of a table in a named schema "David G. Johnston" <david.g.johnston@gmail.com>
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
В списке pgsql-docs по дате отправления
От: PG Doc comments form
Дата:
От: David G. Johnston
Дата:
FAQ