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

> Hi,
>
> I'm running v7.1.2. In psql, if I
>
>   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.

You have found a good bug.  The code knows how to create TEMPORARY
tables and indexes, but not temporary sequences.  What is happening is
that the sequence created is not temporary and will not go away after
session termination.

I will work on fixing it.

The reason the table or index doesn't appear is because temporary stuff
doesn't appear in \d commands.

--
  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