Re: Index not shown - Mailing list pgadmin-support

From Dave Page
Subject Re: Index not shown
Date
Msg-id 03AF4E498C591348A42FC93DEA9661B844B1D1@mail.vale-housing.co.uk
Whole thread Raw
In response to Index not shown  ("Mendola Gaetano" <mendola@bigfoot.com>)
List pgadmin-support

> -----Original Message-----
> From: Mendola Gaetano [mailto:mendola@bigfoot.com]
> Sent: 02 July 2003 13:36
> To: Dave Page; pgadmin-support@postgresql.org
> Subject: Re: [pgadmin-support] Index not shown
>
>
> "Dave Page" <dpage@vale-housing.co.uk> wrote:
> > > -----Original Message-----
> > > From: Mendola Gaetano [mailto:mendola@bigfoot.com]
> > > Sent: 02 July 2003 13:01
> > > To: pgadmin-support@postgresql.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.


pgadmin-support by date:

Previous
From: "Mendola Gaetano"
Date:
Subject: Re: Index not shown
Next
From: Marc Cuypers
Date:
Subject: pgadmin III and query builder