Re: [GENERAL] Temporary tables and miscellaneous schemas

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [GENERAL] Temporary tables and miscellaneous schemas
Дата
Msg-id 19845.1071981430@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [GENERAL] Temporary tables and miscellaneous schemas  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: [GENERAL] Temporary tables and miscellaneous schemas
Re: [GENERAL] Temporary tables and miscellaneous schemas
Список pgsql-patches
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> This patch uses current_schemas('true') to display only the schemas in
> the current search path and implicit schemas.

The more I look at this, the sillier it looks.  It converts \dn into
an expensive substitute for "select current_schemas(true)".  In
practical situations this will mean that \dn shows hardly anything of
interest.

I think the original complaint was misguided and we should not do
anything about it.  IIRC the complaint amounted to "I have hundreds of
schemas and it annoys me that \dn shows them all".  How is this
different from putting hundreds of tables into one schema and then being
annoyed because \dt shows them all?  We have other mechanisms available
for making \dn selective (ie, you can use a name pattern).  If \dn is
restricted to showing only schemas in your search path, it will become
useless.

            regards, tom lane

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [COMMITTERS] pgsql-server/ oc/src/sgml/datatype.sgml rc/bac ...
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [GENERAL] Temporary tables and miscellaneous schemas