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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, "Itzinger, Oskar" <oitzinger(at)opec(dot)org>, PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: Re: [GENERAL] [Help] Temporary Table: Implicitely created index not shown in \d i
Date: 2001-06-22 23:22:04
Message-ID: 6419.993252124@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-patches

I said:
> Hm. Shouldn't psql's \dS ignore temp items, since \d and \di do?

Wait a sec --- I was confusing \dS (display system tables) with \ds
(display sequences). It looks like the latter should get it right
already.

Possibly it does make sense to suppress temp items in \dS, but there
isn't precedent for it. We should discuss it on its own merits.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-06-22 23:29:58 Re: Multiple Indexing, performance impact
Previous Message Peter Eisentraut 2001-06-22 23:21:19 Re: Multiple Indexing, performance impact

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2001-06-23 00:00:46 Re: Re: [GENERAL] [Help] Temporary Table: Implicitely created index not shown in \d i
Previous Message Tom Lane 2001-06-22 23:17:40 Re: Re: [GENERAL] [Help] Temporary Table: Implicitely created index not shown in \d i