Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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

pgsql-patches by date

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

pgsql-general by date

Next:From: Tom LaneDate: 2001-06-22 23:29:58
Subject: Re: Multiple Indexing, performance impact
Previous:From: Peter EisentrautDate: 2001-06-22 23:21:19
Subject: Re: Multiple Indexing, performance impact

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group