Postgres Pro
Downloads
Home   >   mailing lists

Re: [Help] Temporary Table: Implicitely created index not shown in \d i - Mailing list pgsql-general

From Tom Lane
Subject Re: [Help] Temporary Table: Implicitely created index not shown in \d i
Date
Msg-id 22531.992958763@sss.pgh.pa.us
Whole thread Raw
In response to [Help] Temporary Table: Implicitely created index not shown in \d i  ("Itzinger, Oskar" <oitzinger@opec.org>)
List pgsql-general
Tree view 
"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 by date:

Previous
From: "Enrico Mangano"
Date:
Subject: SET TRANSACTION ISOLATION LEVEL SERIALIZABLE on 7.0
Next
From: "Vilson farias"
Date:
Subject: Still getting problems with -cache lookup for userid 26 failed-