Postgres Pro
Downloads
Home   >   mailing lists

Re: Ignored btree indexes on particular tables. - Mailing list pgsql-general

From Richard Huxton
Subject Re: Ignored btree indexes on particular tables.
Date
Msg-id 475EC738.2030700@archonet.com
Whole thread Raw
In response to Re: Ignored btree indexes on particular tables.  ("William Temperley" <willtemperley@gmail.com>)
List pgsql-general
Tree view 
William Temperley wrote:
> Genius!
>
> Thanks Richard,
>
> The old locale was C and the new one English_United Kingdom.1252
> I created a new index with "varchar_pattern_ops" and off it went!

Catches everyone first time.

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: top posting (was: Hijack!)
Next
From: Andrew Sullivan
Date:
Subject: Re: top posting (was: Hijack!)