Обсуждение: 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. Regards Gaetano Mendola
> -----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.
"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
> -----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.