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:
LANG=en_US.UTF-8
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?
Regards,
Steve Tucknott
ReTSol Ltd
DDI: 01903 828769
Mobile: 0773 671 5772 |