Quick Links

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

From:	"Itzinger, Oskar" <oitzinger(at)opec(dot)org>
To:	pgsql-general(at)postgresql(dot)org
Cc:	"Itzinger, Oskar" <oitzinger(at)opec(dot)org>
Subject:	[Help] Temporary Table: Implicitely created index not shown in \d i
Date:	2001-06-19 08:32:36
Message-ID:	FD2A5FEE4C3AD511A77B00508BB8538A01198D@OPECEXCH
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general pgsql-patches

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.

Why ???

Thanks.

/oskar

Responses

Re: [Help] Temporary Table: Implicitely created index not shown in \d i at 2001-06-19 13:52:43 from Tom Lane
Re: [Help] Temporary Table: Implicitely created index not shown in \d i at 2001-06-21 18:54:45 from Bruce Momjian
Re: [GENERAL] [Help] Temporary Table: Implicitely created index not shown in \d i at 2001-06-22 23:04:19 from Bruce Momjian

Browse pgsql-general by date

	From	Date	Subject
Next Message	Peep Krusberg	2001-06-19 08:54:39
Previous Message	Richard Huxton	2001-06-19 08:32:25	Re: Alternate Database Location.

Browse pgsql-patches by date

	From	Date	Subject
Next Message	Tom Lane	2001-06-19 13:52:43	Re: [Help] Temporary Table: Implicitely created index not shown in \d i
Previous Message	Bruce Momjian	2001-06-18 23:41:10	Re: use GUC for cmdline