Re: [pgadmin-support] text_pattern_ops not shown in index command

2006-11-27 Thread Dave Page
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_pa

[pgadmin-support] text_pattern_ops not shown in index command

2006-11-26 Thread Andrus
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 b