bpchar_pattern_ops not shown in index command

From: "Andrus" <eetasoft(at)online(dot)ee>
To: pgadmin-support(at)postgresql(dot)org
Subject: bpchar_pattern_ops not shown in index command
Date: 2006-06-06 08:17:29
Message-ID: e63dnf$2pk0$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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.

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Mr. DBA 2006-06-06 17:02:12 starting/stopping service from windows not working
Previous Message Jeremy Palmer 2006-06-05 08:26:02 Problems with SVN win32 build.