Skip site navigation (1) Skip section navigation (2)

Re: bpchar_pattern_ops not shown in index command

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Andrus" <eetasoft(at)online(dot)ee>,<pgadmin-support(at)postgresql(dot)org>
Subject: Re: bpchar_pattern_ops not shown in index command
Date: 2006-06-12 11:13:00
Message-ID: E7F85A1B5FF8D44C8A1AF6885BC9A0E401388880@ratbert.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgadmin-support
 

> -----Original Message-----
> From: pgadmin-support-owner(at)postgresql(dot)org 
> [mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of Andrus
> Sent: 06 June 2006 09:17
> To: pgadmin-support(at)postgresql(dot)org
> 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

pgadmin-support by date

Next:From: Dave PageDate: 2006-06-12 11:56:19
Subject: Re: Postgres question
Previous:From: Dave PageDate: 2006-06-12 07:55:41
Subject: Re: Problems with pgagent Jobs

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group