Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgadmin-support by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group