> -----Original Message----- > From: Mendola Gaetano [mailto:[EMAIL PROTECTED] > Sent: 02 July 2003 13:36 > To: Dave Page; [EMAIL PROTECTED] > Subject: Re: [pgadmin-support] Index not shown > > > "Dave Page" <[EMAIL PROTECTED]> wrote: > > > -----Original Message----- > > > From: Mendola Gaetano [mailto:[EMAIL PROTECTED] > > > Sent: 02 July 2003 13:01 > > > To: [EMAIL PROTECTED] > > > 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. ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly