pgsql: Need to use pg_perm_setlocale when setting LC_CTYPE and

From: heikki(at)postgresql(dot)org (Heikki Linnakangas)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Need to use pg_perm_setlocale when setting LC_CTYPE and
Date: 2009-07-08 17:53:29
Message-ID: 20090708175329.BD2D875331E@cvs.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

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)

Browse pgsql-committers by date

  From Date Subject
Next Message Heikki Linnakangas 2009-07-08 17:53:32 pgsql: Need to use pg_perm_setlocale when setting LC_CTYPE and
Previous Message Tom Lane 2009-07-08 17:22:01 pgsql: Add missing HOUR TO SECOND option to list of possible INTERVAL