Thanks Gus I solved it with a dump/initdb --locale=/load. Possibly not the deb-done-thing? I will get our friendly local deb-head to fix it all nicely on return from Hols.
Works a treat. Stu > At Thu, 6 Jan 2005 16:16:05 +1100 (EST), Stuart Guthrie wrote: >> So Debian seems to be initialising postgres dbs with the first of these >> collate sequences meaning that whatever 'C' is seems to return >> case-sensitive search results. >> >> Mandrake's standard RPM implements postgres with en_US collation >> sequences >> which means it sorts AaBbCcDd which is what I'd be hoping for. > > Run "dpkg-reconfigure --priority=low postgresql". One of the > questions is what encoding you want to use by default (although since > you obviously *rely* on the encoding, then I'd suggest mentioning it > explicitly in the CREATE DATABASE statement anyway). > > -- > - Gus > > -- SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/ Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html
