Re: can't see operator classes - Mailing list pgadmin-support

Erbil KARAMAN wrote:
> i use pgAdminIII (Win32 binary) version 1.4.3 to test my relational DB
> running on Postgresql v8.1.3.
> 
> For some indexes i use operator classes such as varchar_pattern_ops
> for LIKE selections. but i cant see the operator class definition in
> pgAdmin table "properties". They are seen in dumps that i have created
> with pg_dump.
> 
> ex:
> 
> dump file segment created by pg_dump for index__xxx_yyy
> --------------------------------------------
> CREATE UNIQUE INDEX index__xxx_yyy ON xxx USING btree (yyy 
> varchar_pattern_ops);
> 
> pgAdmin properties section for index__xxx__yyy
> ----------------------------------------
> CREATE UNIQUE INDEX index__xxx__yyy
>  ON xxx
>  USING btree
>  (yyy);
> 
> is there a way to see such operator classes?

This should work in the newly uploaded pgAdmin 1.6.1: 
http://developer.pgadmin.org/ftp/release/v1.6.1/
From the changelog:

2006-11-27 DP  1.6.1  Fix a minor bug in the index reverse engineering 
when using non-default operator classes per Andrus.

Regards, Dave