bpchar_pattern_ops not shown in index command
require($_SERVER['DOCUMENT_ROOT']."/includes/top_config.php");
?>
bpchar_pattern_ops not shown in index command
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.
Home |
Main Index |
Thread Index