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: (view raw, whole thread or download thread mbox)
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:

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-2017 The PostgreSQL Global Development Group