From: | Dave Page <dpage(at)postgresql(dot)org> |
---|---|
To: | Erbil KARAMAN <erbilkaraman(at)gmail(dot)com> |
Cc: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: can't see operator classes |
Date: | 2006-11-30 13:30:50 |
Message-ID: | 456EDD0A.6010306@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Hélder M. Vieira | 2006-11-30 15:21:51 | Re: Backup/Restore |
Previous Message | Erbil KARAMAN | 2006-11-30 13:19:22 | can't see operator classes |