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

Re: automatic indices not showing (win32/rev7358)

From: "Dave Page" <dpage(at)pgadmin(dot)org>
To: Kev <kevinjamesfield(at)gmail(dot)com>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: automatic indices not showing (win32/rev7358)
Date: 2008-11-18 14:57:04
Message-ID: 937d27e10811180657xff3ca3bwf517393495380341@mail.gmail.com (view raw or flat)
Thread:
Lists: pgadmin-support
On Tue, Nov 18, 2008 at 2:25 PM, Kev <kevinjamesfield(at)gmail(dot)com> wrote:
> When I create a table with a PK, and get a notice of the form:
>
> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "(table)
> _pkey" for table "(table)"
>
> Indeed, the index it mentions shows up in pg_index.  pgAdmin, however,
> shows zero indices under the table, even after refreshing the table or
> even restarting the program.  Is this supposed to be this way?

Yes. It lives under the Constraints node. The fact that it is an index
is an implementation detail.


-- 
Dave Page
EnterpriseDB UK:   http://www.enterprisedb.com

In response to

pgadmin-support by date

Next:From: Mauro BertoliDate: 2008-11-18 15:27:49
Subject: PgAdmin III keep-alive
Previous:From: KevDate: 2008-11-18 14:25:06
Subject: automatic indices not showing (win32/rev7358)

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