Thread: automatic indices not showing (win32/rev7358)

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?

On Tue, Nov 18, 2008 at 2:25 PM, Kev <kevinjamesfield@gmail.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