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.
EnterpriseDB UK: http://www.enterprisedb.com
In response to
pgadmin-support by date
|Next:||From: Mauro Bertoli||Date: 2008-11-18 15:27:49|
|Subject: PgAdmin III keep-alive|
|Previous:||From: Kev||Date: 2008-11-18 14:25:06|
|Subject: automatic indices not showing (win32/rev7358)|