diff options
| author | Heikki Linnakangas <heikki.linnakangas@iki.fi> | 2009-07-08 17:53:29 +0000 |
|---|---|---|
| committer | Heikki Linnakangas <heikki.linnakangas@iki.fi> | 2009-07-08 17:53:29 +0000 |
| commit | e5bb0f04db225a06e08b9b74cde82325c87a8de3 (patch) | |
| tree | dfc5de0e6e4852d35d959dfc5c3a0fdfdc85a23b /src/backend/utils/init/postinit.c | |
| parent | 53e7229258cb6463cffa70c9be20b9630aed8940 (diff) | |
| download | postgresql-e5bb0f04db225a06e08b9b74cde82325c87a8de3.tar.gz postgresql-e5bb0f04db225a06e08b9b74cde82325c87a8de3.zip | |
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.
Diffstat (limited to 'src/backend/utils/init/postinit.c')
| -rw-r--r-- | src/backend/utils/init/postinit.c | 7 |
1 files changed, 4 insertions, 3 deletions
diff --git a/src/backend/utils/init/postinit.c b/src/backend/utils/init/postinit.c index 34685cba3ce..bdb2fec1043 100644 --- a/src/backend/utils/init/postinit.c +++ b/src/backend/utils/init/postinit.c @@ -8,7 +8,7 @@ * * * IDENTIFICATION - * $PostgreSQL: pgsql/src/backend/utils/init/postinit.c,v 1.191 2009/06/11 14:49:05 momjian Exp $ + * $PostgreSQL: pgsql/src/backend/utils/init/postinit.c,v 1.192 2009/07/08 17:53:29 heikki Exp $ * * *------------------------------------------------------------------------- @@ -44,6 +44,7 @@ #include "utils/acl.h" #include "utils/flatfiles.h" #include "utils/guc.h" +#include "utils/pg_locale.h" #include "utils/plancache.h" #include "utils/portal.h" #include "utils/relcache.h" @@ -247,14 +248,14 @@ CheckMyDatabase(const char *name, bool am_superuser) collate = NameStr(dbform->datcollate); ctype = NameStr(dbform->datctype); - if (setlocale(LC_COLLATE, collate) == NULL) + if (pg_perm_setlocale(LC_COLLATE, collate) == NULL) ereport(FATAL, (errmsg("database locale is incompatible with operating system"), errdetail("The database was initialized with LC_COLLATE \"%s\", " " which is not recognized by setlocale().", collate), errhint("Recreate the database with another locale or install the missing locale."))); - if (setlocale(LC_CTYPE, ctype) == NULL) + if (pg_perm_setlocale(LC_CTYPE, ctype) == NULL) ereport(FATAL, (errmsg("database locale is incompatible with operating system"), errdetail("The database was initialized with LC_CTYPE \"%s\", " |