Re: Re: [GENERAL] [Help] Temporary Table: Implicitely created index not shown in \d i

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Re: [GENERAL] [Help] Temporary Table: Implicitely created index not shown in \d i
Дата
Msg-id 200106230000.f5N00km08631@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: Re: [GENERAL] [Help] Temporary Table: Implicitely created index not shown in \d i  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-patches
> I said:
> > Hm.  Shouldn't psql's \dS ignore temp items, since \d and \di do?
>
> Wait a sec --- I was confusing \dS (display system tables) with \ds
> (display sequences).  It looks like the latter should get it right
> already.


test=> \ds
No relations found.

> Possibly it does make sense to suppress temp items in \dS, but there
> isn't precedent for it.  We should discuss it on its own merits.

If we don't show temp items with \dS we need another backslash command
to show temp stuff.  Doesn't seem worth it, especially since we don't
show much info about temp stuff except that numeric name.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Re: [GENERAL] [Help] Temporary Table: Implicitely created index not shown in \d i
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: use GUC for cmdline