bpchar_pattern_ops not shown in index command
От
Andrus
Тема
bpchar_pattern_ops not shown in index command
Дата
Msg-id
e63dnf$2pk0$1@news.hub.org
Список
Дерево обсуждения
text_pattern_ops not shown in index command "Andrus" <kobruleht2@hot.ee>
Re: text_pattern_ops not shown in index command Dave Page <dpage@postgresql.org>
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.
В списке pgadmin-support по дате отправления