On Tue, Nov 18, 2008 at 2:25 PM, Kev <[EMAIL PROTECTED]> 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 -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
