To reproduce, run: create table foo ( bar char(20)); CREATE UNIQUE INDEX bar_pattern_idx ON foo(LOWER(bar) bpchar_pattern_ops); Observed in pgadmin: CREATE UNIQUE INDEX bar_pattern_idx ON foo USING btree (lower(bar::text)); Expected: bpchar_pattern_ops clause must also be present Platform: PgAdmin 1.4.0 on Windows XP with Postgres 8.1 Andrus.