Postgres Pro
Downloads
Home   >   mailing lists

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

From Bruce Momjian
Subject Re: [Help] Temporary Table: Implicitely created index not shown in \d i
Date
Msg-id 200106211854.f5LIsjM28638@candle.pha.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 
> 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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: WAL failure?
Next
From: will trillich
Date:
Subject: Re: newbie primary key problem