Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 6B31A634FB7 for ; Wed, 8 Jul 2009 14:55:51 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 97990-07 for ; Wed, 8 Jul 2009 14:55:40 -0300 (ADT) Received: from cvs.postgresql.org (cvs.postgresql.org [217.196.146.206]) by mail.postgresql.org (Postfix) with ESMTP id A94BB632ADE for ; Wed, 8 Jul 2009 14:53:33 -0300 (ADT) Received: by cvs.postgresql.org (Postfix, from userid 1198) id AAC3375331E; Wed, 8 Jul 2009 17:53:32 +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: <20090708175332.AAC3375331E@cvs.postgresql.org> Date: Wed, 8 Jul 2009 17:53:32 +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/99 X-Sequence-Number: 37702 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. Tags: ---- REL8_4_STABLE Modified Files: -------------- pgsql/src/backend/utils/init: postinit.c (r1.191 -> r1.191.2.1) (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/init/postinit.c?r1=1.191&r2=1.191.2.1)