Re: Unclear wording
От | Laurenz Albe |
---|---|
Тема | Re: Unclear wording |
Дата | |
Msg-id | dd69c01c44c475f0f651f09e1b1a3d742d49714e.camel@cybertec.at обсуждение исходный текст |
Ответ на | Unclear wording (PG Doc comments form <noreply@postgresql.org>) |
Список | pgsql-docs |
On Fri, 2025-07-11 at 16:12 +0000, PG Doc comments form wrote: > Page: https://www.postgresql.org/docs/17/ddl-schemas.html > Description: > > In §5.10.3 these two sentences seem inconsistent: > > > When objects are referenced in any other context without schema > qualification...the search path is traversed until a matching object is > found. Therefore, in the default configuration, any unqualified access again > can only refer to the public schema. > > Either unqualified access can refer to any schema in the search path, > because the search path is traversed until a matching object is found, or > else unqualified access can only refer to the public schema because the > search path will not be traversed looking in other schemas for a matching > object, but both of those possibilities conflict with one or the other of > the sentences quoted from the manual. > > Obviously I'm missing something; I don't know which of the two sentences > quoted from the manual to believe, or if I am to understand both are true, > what I am misunderstanding about their meaning. I don't see an inconsistency. The key phrase is "in the default configuration". The default value for 'search_path' is '"$user", public'. Now by default there is no schema with the same name as the database user, so the effective default search path is just the 'public' schema. Yours, Laurenz Albe
В списке pgsql-docs по дате отправления: