Dave Page wrote:



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


No, this is brand new, while trying to implement the new 7.4 index stuff :-)

Will be fixed soon.

Regards,
Andreas




---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster

Reply via email to