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
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
