Re: describe working as intended?

Поиск
Список
Период
Сортировка
От Sergei Kornilov
Тема Re: describe working as intended?
Дата
Msg-id 9206511558167466@iva1-80ce53b21b01.qloud-c.yandex.net
обсуждение исходный текст
Ответ на describe working as intended?  (Melanie Plageman <melanieplageman@gmail.com>)
Ответы Re: describe working as intended?  (Melanie Plageman <melanieplageman@gmail.com>)
Список pgsql-hackers
Hello

No, this is not bug. This is expected beharior of search_path setting:
https://www.postgresql.org/docs/current/runtime-config-client.html

> Likewise, the current session's temporary-table schema, pg_temp_nnn, is always searched if it exists. It can be
explicitlylisted in the path by using the alias pg_temp. If it is not listed in the path then it is searched first
 

psql \d command checks current search_path (by pg_table_is_visible call). You can use \d *.t1 syntax to display tables
withsuch name in all schemas.
 

regards, Sergei



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

Предыдущее
От: Andrey Borodin
Дата:
Сообщение: Re: pglz performance
Следующее
От: Dean Rasheed
Дата:
Сообщение: Re: Multivariate MCV stats can leak data to unprivileged users