Received: from sss.pgh.pa.us ([192.204.191.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fASHDTm84652 for ; Wed, 28 Nov 2001 12:13:29 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id fASHDUk02778; Wed, 28 Nov 2001 12:13:30 -0500 (EST) To: Vincent.Gaboriau@answare.fr cc: "'pgsql-admin@postgresql.org'" Subject: Re: [HACKERS] upper and lower doesn't work with german In-reply-to: <3C051482.908DEDFF@answare.fr> References: <20011127085555.A20745-100000@megazone23.bigpanda.com> <3C04A23E.BF409D74@answare.fr> <2131.1006960265@sss.pgh.pa.us> <3C0510FF.694D34EA@answare.fr> <2528.1006965329@sss.pgh.pa.us> <3C051482.908DEDFF@answare.fr> Comments: In-reply-to Vincent.Gaboriau@answare.fr message dated "Wed, 28 Nov 2001 17:44:50 +0100" Date: Wed, 28 Nov 2001 12:13:29 -0500 Message-ID: <2775.1006967609@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200111/155 X-Sequence-Number: 2680 Vincent.Gaboriau@answare.fr writes: >> Er ... *what* version did you say you were running? That doesn't look >> like a 7.1 pg_control to me. > No, I have an 7.0.2 on Linux Mandrake 7.2. Time to update then. 7.0 doesn't freeze the LC_COLLATE setting at initdb, which means that you can corrupt your indexes by starting the postmaster with different LC settings at different times. Which is depressingly easy to do. regards, tom lane