/*----------------------------------------------------------------------- * * PostgreSQL locale utilities * * Portions Copyright (c) 2002-2004, PostgreSQL Global Development Group * * $PostgreSQL: pgsql/src/backend/utils/adt/pg_locale.c,v 1.29 2004/10/17 20:02:26 tgl Exp $ * *----------------------------------------------------------------------- */ /*---------- * Here is how the locale stuff is handled: LC_COLLATE and LC_CTYPE * are fixed by initdb, stored in pg_control, and cannot be changed. * Thus, the effects of strcoll(), strxfrm(), isupper(), toupper(), * etc. are always in the same fixed locale. * * LC_MESSAGES is settable at run time and will take effect * immediately. * * The other categories, LC_MONETARY, LC_NUMERIC, and LC_TIME are also * settable at run-time. However, we don't actually set those locale * categories permanently. This would have bizarre effects like no * longer accepting standard floating-point literals in some locales. * Instead, we only set the locales briefly when needed, cache the * required information obtained from localeconv(), and set them back. * The cached information is only used by the formatting functions * (to_char, etc.) and the money type. For the user, this should all be * transparent. (Actually, LC_TIME doesn't do anything at all right * now.) * * !!! NOW HEAR THIS !!! * * We've been bitten repeatedly by this bug, so let's try to keep it in * mind in future: on some platforms, the locale functions return pointers * to static data that will be overwritten by any later locale function. * Thus, for example, the obvious-looking sequence * save = setlocale(category, NULL); * if (!setlocale(category, value)) * fail = true; * setlocale(category, save); * DOES NOT WORK RELIABLY: on some platforms the second setlocale() call * will change the memory save is pointing at. To do this sort of thing * safely, you *must* pstrdup what setlocale returns the first time. *---------- */ #include "postgres.h" #include #include "utils/pg_locale.h" /* indicated whether locale information cache is valid */ static bool CurrentLocaleConvValid = false; /* GUC storage area */ char *locale_messages; char *locale_monetary; char *locale_numeric; char *locale_time; /* GUC assign hooks */ /* * This is common code for several locale categories. This doesn't * actually set the locale permanently, it only tests if the locale is * valid. (See explanation at the top of this file.) */ static const char * locale_xxx_assign(int category, const char *value, bool doit, GucSource source) { char *save; save = setlocale(category, NULL); if (!save) return NULL; /* won't happen, we hope */ /* save may be pointing at a modifiable scratch variable, see above */ save = pstrdup(save); if (!setlocale(category, value)) value = NULL; /* set failure return marker */ setlocale(category, save); /* assume this won't fail */ pfree(save); /* need to reload cache next time? */ if (doit && value != NULL) CurrentLocaleConvValid = false; return value; } const char * locale_monetary_assign(const char *value, bool doit, GucSource source) { return locale_xxx_assign(LC_MONETARY, value, doit, source); } const char * locale_numeric_assign(const char *value, bool doit, GucSource source) { return locale_xxx_assign(LC_NUMERIC, value, doit, source); } const char * locale_time_assign(const char *value, bool doit, GucSource source) { return locale_xxx_assign(LC_TIME, value, doit, source); } /* * We allow LC_MESSAGES to actually be set globally. */ const char * locale_messages_assign(const char *value, bool doit, GucSource source) { #ifndef WIN32 /* * LC_MESSAGES category does not exist everywhere, but accept it * anyway */ #ifdef LC_MESSAGES if (doit) { if (!setlocale(LC_MESSAGES, value)) return NULL; } else value = locale_xxx_assign(LC_MESSAGES, value, false, source); #endif /* LC_MESSAGES */ return value; #else /* WIN32 */ /* * Win32 does not have working setlocale() for LC_MESSAGES. We can only * use environment variables to change it (per gettext FAQ). This * means we can't actually check the supplied value, so always assume * it's good. Also, ignore attempts to set to "", which really means * "keep using the old value". (Actually it means "use the environment * value", but we are too lazy to try to implement that exactly.) */ if (doit && value[0]) { /* * We need to modify both the process environment and the cached * version in msvcrt */ static char env[128]; if (!SetEnvironmentVariable("LC_MESSAGES", value)) return NULL; snprintf(env, sizeof(env)-1, "LC_MESSAGES=%s", value); if (_putenv(env)) return NULL; } return value; #endif /* WIN32 */ } /* * We'd like to cache whether LC_COLLATE is C (or POSIX), so we can * optimize a few code paths in various places. */ bool lc_collate_is_c(void) { /* Cache result so we only have to compute it once */ static int result = -1; char *localeptr; if (result >= 0) return (bool) result; localeptr = setlocale(LC_COLLATE, NULL); if (!localeptr) elog(ERROR, "invalid LC_COLLATE setting"); if (strcmp(localeptr, "C") == 0) result = true; else if (strcmp(localeptr, "POSIX") == 0) result = true; else result = false; return (bool) result; } /* * Frees the malloced content of a struct lconv. (But not the struct * itself.) */ static void free_struct_lconv(struct lconv * s) { if (s == NULL) return; if (s->currency_symbol) free(s->currency_symbol); if (s->decimal_point) free(s->decimal_point); if (s->grouping) free(s->grouping); if (s->thousands_sep) free(s->thousands_sep); if (s->int_curr_symbol) free(s->int_curr_symbol); if (s->mon_decimal_point) free(s->mon_decimal_point); if (s->mon_grouping) free(s->mon_grouping); if (s->mon_thousands_sep) free(s->mon_thousands_sep); if (s->negative_sign) free(s->negative_sign); if (s->positive_sign) free(s->positive_sign); } /* * Return the POSIX lconv struct (contains number/money formatting * information) with locale information for all categories. */ struct lconv * PGLC_localeconv(void) { static struct lconv CurrentLocaleConv; struct lconv *extlconv; char *save_lc_monetary; char *save_lc_numeric; /* Did we do it already? */ if (CurrentLocaleConvValid) return &CurrentLocaleConv; free_struct_lconv(&CurrentLocaleConv); /* Set user's values of monetary and numeric locales */ save_lc_monetary = setlocale(LC_MONETARY, NULL); if (save_lc_monetary) save_lc_monetary = pstrdup(save_lc_monetary); save_lc_numeric = setlocale(LC_NUMERIC, NULL); if (save_lc_numeric) save_lc_numeric = pstrdup(save_lc_numeric); setlocale(LC_MONETARY, locale_monetary); setlocale(LC_NUMERIC, locale_numeric); /* Get formatting information */ extlconv = localeconv(); /* * Must copy all values since restoring internal settings may * overwrite localeconv()'s results. */ CurrentLocaleConv = *extlconv; CurrentLocaleConv.currency_symbol = strdup(extlconv->currency_symbol); CurrentLocaleConv.decimal_point = strdup(extlconv->decimal_point); CurrentLocaleConv.grouping = strdup(extlconv->grouping); CurrentLocaleConv.thousands_sep = strdup(extlconv->thousands_sep); CurrentLocaleConv.int_curr_symbol = strdup(extlconv->int_curr_symbol); CurrentLocaleConv.mon_decimal_point = strdup(extlconv->mon_decimal_point); CurrentLocaleConv.mon_grouping = strdup(extlconv->mon_grouping); CurrentLocaleConv.mon_thousands_sep = strdup(extlconv->mon_thousands_sep); CurrentLocaleConv.negative_sign = strdup(extlconv->negative_sign); CurrentLocaleConv.positive_sign = strdup(extlconv->positive_sign); CurrentLocaleConv.n_sign_posn = extlconv->n_sign_posn; /* Try to restore internal settings */ if (save_lc_monetary) { setlocale(LC_MONETARY, save_lc_monetary); pfree(save_lc_monetary); } if (save_lc_numeric) { setlocale(LC_NUMERIC, save_lc_numeric); pfree(save_lc_numeric); } CurrentLocaleConvValid = true; return &CurrentLocaleConv; }