> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Andrus
> Sent: 06 June 2006 09:17
> To: [email protected]
> Subject: [pgadmin-support] 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));
This appears to be an issue with the PostgreSQL function pg_get_indexdef
- I've raised the issue on -hackers.
Regards, Dave
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
