PostgreSQL 8.0.3 Fedora Core4
I have moved a database from 7.4.5 to 8.0.3. My land setting when
initdb'ing the 8.0.3 cluster was:
>From recollection, under 7.4.5 my collate sequence etc in the config
(although commented out) was 'C'.
The issue is under 7.4.5 the LIKE 'A%' used indexes to find data - under
the new 8.0.3 database it doesn't. Two questions: 1) should LIKE 'A%'
use an index under the en_US locale? 2) if not is the only way to
correct this is to export the databases, re init with a different locale
('C'?) and then restore?
DDI: 01903 828769
Mobile: 0773 671 5772
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2005-10-11 13:47:31|
|Subject: Re: LIKE.....and Locale |
|Previous:||From: Paresh Bafna||Date: 2005-10-11 07:14:50|
|Subject: Multi-relation/column keyword indices|