Re: Index not shown

> -----Original Message-----
> From: Mendola Gaetano [mailto:mendola(at)bigfoot(dot)com]
> Sent: 02 July 2003 13:36
> To: Dave Page; pgadmin-support(at)postgresql(dot)org
> Subject: Re: [pgadmin-support] Index not shown
>
>
> "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> wrote:
> > > -----Original Message-----
> > > From: Mendola Gaetano [mailto:mendola(at)bigfoot(dot)com]
> > > Sent: 02 July 2003 13:01
> > > To: pgadmin-support(at)postgresql(dot)org
> > > Subject: [pgadmin-support] Index not shown
> > >
> > >
> > > I hava a table with 16 indexes
> > > and 2 UNIQUE constraint.
> > > On the indexes list I see only the 16 indexes,
> > > BTW that 2 UNIQUE constraint are indexes too.
> >
> > Is this pgAdmin II or III?
>
> Is pgAdminII.

OK, on the View menu, there is an option to show system objects. By
default pgAdmin will hide 'constraint indexes', e.g. those that are
created to enforce constraints on the data.

> I tried with pgAdminIII and I get: Attribute "indnatts" not
> found ( the server is Postgres 7.3.3), the same error with all tables.

I believe this is an old bug that is now fixed. pgAdmin III is maturing
pretty quickly...

Regards, Dave.