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