Re: text_pattern_ops not shown in index command - Mailing list pgadmin-support

Andrus wrote:
> To reproduce:
> 
> create table foo ( bar char(20));
> CREATE UNIQUE INDEX bar_pattern_idx ON foo(LOWER(bar) text_pattern_ops);
> 
> Observed in pgAdmin 1.6 post beta-1 table definition pane:
> 
> CREATE UNIQUE INDEX bar_pattern_idx
>   ON foo
>   USING btree
>   (lower(bar::text));
> 
> Expected:
> 
> text_pattern_ops must be present

Thanks, fixed in SVN.

Regards, Dave