Обсуждение: can't see operator classes
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? advTHANKSance erbiL...
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