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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [Help] Temporary Table: Implicitely created index not shown in \d i
Дата
Msg-id 22531.992958763@sss.pgh.pa.us
обсуждение исходный текст
Ответ на [Help] Temporary Table: Implicitely created index not shown in \d i  ("Itzinger, Oskar" <oitzinger@opec.org>)
Список pgsql-general
"Itzinger, Oskar" <oitzinger@opec.org> writes:
>   CREATE TEMPORARY TABLE junk (col1 SERIAL, <more cols>)
> and check \ds, the implicitely created sequence is shown but \di doesn't
> show the implicitely created index.

\d and \di don't show temp tables and indexes.

The sequence object should be temp as well, but is not at the moment.

            regards, tom lane

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

Предыдущее
От: "Enrico Mangano"
Дата:
Сообщение: SET TRANSACTION ISOLATION LEVEL SERIALIZABLE on 7.0
Следующее
От: "Vilson farias"
Дата:
Сообщение: Still getting problems with -cache lookup for userid 26 failed-