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
Список
Дерево обсуждения
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 по дате отправления
От: David G. Johnston
Дата: