Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 4B36C6350A2 for ; Wed, 8 Jul 2009 14:55:49 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 81635-01-3 for ; Wed, 8 Jul 2009 14:55:35 -0300 (ADT) Received: from cvs.postgresql.org (cvs.postgresql.org [217.196.146.206]) by mail.postgresql.org (Postfix) with ESMTP id 1624763290F for ; Wed, 8 Jul 2009 14:53:31 -0300 (ADT) Received: by cvs.postgresql.org (Postfix, from userid 1198) id BD2D875331E; Wed, 8 Jul 2009 17:53:29 +0000 (UTC) MIME-Version: 1.0 To: pgsql-committers@postgresql.org Subject: pgsql: Need to use pg_perm_setlocale when setting LC_CTYPE and X-Mailer: activitymail 1.24, http://search.cpan.org/dist/activitymail/ Content-Type: text/plain Message-Id: <20090708175329.BD2D875331E@cvs.postgresql.org> Date: Wed, 8 Jul 2009 17:53:29 +0000 (UTC) From: heikki@postgresql.org (Heikki Linnakangas) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200907/98 X-Sequence-Number: 37701 Log Message: ----------- Need to use pg_perm_setlocale when setting LC_CTYPE and LC_COLLATE at startup. Otherwise, the LC_CTYPE/COLLATE setting gets reverted when using plperl, which leads to incorrect query results and index corruption. This was accidentally broken in the per-database locale patch in 8.4. Pointed out by Andrew Gierth. Modified Files: -------------- pgsql/src/backend/utils/init: postinit.c (r1.191 -> r1.192) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/init/postinit.c?r1=1.191&r2=1.192)