Re: Ignored btree indexes on particular tables.

From: "William Temperley" <willtemperley(at)gmail(dot)com>
To: "Richard Huxton" <dev(at)archonet(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Ignored btree indexes on particular tables.
Date: 2007-12-11 17:07:16
Message-ID: 439dc11e0712110907s157fa779wa8f18d14f44df78c@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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!

> the strange thing is my btree indexes on the uk roads data work fine.
>
> Do they use like, or explicit range-checks?
>
> I wasn't using like, which is why they were working. adding a new index
then using the like operator didn't work.

Thanks again.

Will

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2007-12-11 17:11:45 Re: top posting (was: Hijack!)
Previous Message Gregory Williamson 2007-12-11 17:03:39 Re: Hijack!