Postgres Pro
Downloads
Home   >   mailing lists

Thread: Index not shown

Index not shown

From
"Mendola Gaetano"
Date:
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.


Regards
Gaetano Mendola

Re: Index not shown

From
"Dave Page"
Date:

> -----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?

Regards, Dave.

Re: Index not shown

From
"Mendola Gaetano"
Date:
"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.I tried with pgAdminIII and I get: Attribute "indnatts" not found
( the server is Postgres 7.3.3), the same error with all tables.

Regards
Gaetano Mendola

Re: Index not shown

From
"Dave Page"
Date:

> -----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.