Re: text_pattern_ops not shown in index command

From: Dave Page <dpage(at)postgresql(dot)org>
To: Andrus <kobruleht2(at)hot(dot)ee>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: text_pattern_ops not shown in index command
Date: 2006-11-27 11:32:19
Message-ID: 456ACCC3.30900@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Andrus wrote:
> To reproduce:
>
> create table foo ( bar char(20));
> CREATE UNIQUE INDEX bar_pattern_idx ON foo(LOWER(bar) text_pattern_ops);
>
> Observed in pgAdmin 1.6 post beta-1 table definition pane:
>
> CREATE UNIQUE INDEX bar_pattern_idx
> ON foo
> USING btree
> (lower(bar::text));
>
> Expected:
>
> text_pattern_ops must be present

Thanks, fixed in SVN.

Regards, Dave

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Markus Schaber 2006-11-27 13:48:06 Re: [SQL] PgAgent [where is it?]
Previous Message Dave Page 2006-11-26 19:35:57 Re: vacuum tip question