Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Mon, 27 Nov 2006 11:32:19 +0000
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
- References:
- text_pattern_ops not shown in index command
- From: Andrus
- text_pattern_ops not shown in index command
- Prev by Date: Re: vacuum tip question
- Next by Date: Re: [SQL] PgAgent [where is it?]
- Previous by thread: text_pattern_ops not shown in index command
- Next by thread: vacuum tip question
- Indexes: