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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Itzinger, Oskar" <oitzinger(at)opec(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [Help] Temporary Table: Implicitely created index not shown in \d i
Date: 2001-06-19 13:52:43
Message-ID: 22531.992958763@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-patches

"Itzinger, Oskar" <oitzinger(at)opec(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-06-19 13:55:15 Re: Update and cursor
Previous Message Vilson farias 2001-06-19 13:42:35 Still getting problems with -cache lookup for userid 26 failed-

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2001-06-19 14:20:18 Re: [PATCHES] [PATCH] Contrib C source for casting MONEY to INT[248] and FLOAT[48]
Previous Message Itzinger, Oskar 2001-06-19 08:32:36 [Help] Temporary Table: Implicitely created index not shown in \d i