| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | "pugin2011ilya(at)gmail(dot)com" <pugin2011ilya(at)gmail(dot)com>, "pgsql-docs(at)lists(dot)postgresql(dot)org" <pgsql-docs(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: DROP INDEX - dropping index of a table in a named schema |
| Date: | 2023-05-22 14:13:37 |
| Message-ID: | CAKFQuwa=X0bQbPKwMC0HL8Ka+9vSQec-Q8QcgoX=U2BevpxP=w@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
On Monday, May 22, 2023, PG Doc comments form <noreply(at)postgresql(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | PG Doc comments form | 2023-05-23 20:52:25 | Typo |
| Previous Message | PG Doc comments form | 2023-05-22 13:43:22 | DROP INDEX - dropping index of a table in a named schema |