pg_locale.c File Reference

#include "postgres.h"
#include <time.h>
#include "access/htup_details.h"
#include "catalog/pg_collation.h"
#include "catalog/pg_control.h"
#include "mb/pg_wchar.h"
#include "utils/builtins.h"
#include "utils/formatting.h"
#include "utils/guc_hooks.h"
#include "utils/hsearch.h"
#include "utils/lsyscache.h"
#include "utils/memutils.h"
#include "utils/pg_locale.h"
#include "utils/syscache.h"

Include dependency graph for pg_locale.c:

Go to the source code of this file.

Data Structures
struct	collation_cache_entry

Macros
#define	TEXTBUFLEN   1024
#define	MAX_L10N_DATA   80

Functions
char *	pg_perm_setlocale (int category, const char *locale)
bool	check_locale (int category, const char *locale, char **canonname)
bool	check_locale_monetary (char **newval, void **extra, GucSource source)
void	assign_locale_monetary (const char *newval, void *extra)
bool	check_locale_numeric (char **newval, void **extra, GucSource source)
void	assign_locale_numeric (const char *newval, void *extra)
bool	check_locale_time (char **newval, void **extra, GucSource source)
void	assign_locale_time (const char *newval, void *extra)
bool	check_locale_messages (char **newval, void **extra, GucSource source)
void	assign_locale_messages (const char *newval, void *extra)
static void	free_struct_lconv (struct lconv *s)
static bool	struct_lconv_is_valid (struct lconv *s)
static void	db_encoding_convert (int encoding, char **str)
struct lconv *	PGLC_localeconv (void)
static void	cache_single_string (char **dst, const char *src, int encoding)
void	cache_locale_time (void)
void	check_strxfrm_bug (void)
static collation_cache_entry *	lookup_collation_cache (Oid collation, bool set_flags)
bool	lc_collate_is_c (Oid collation)
bool	lc_ctype_is_c (Oid collation)
void	make_icu_collator (const char *iculocstr, const char *icurules, struct pg_locale_struct *resultp)
bool	pg_locale_deterministic (pg_locale_t locale)
pg_locale_t	pg_newlocale_from_collation (Oid collid)
char *	get_collation_actual_version (char collprovider, const char *collcollate)
static int	pg_strcoll_libc (const char *arg1, const char *arg2, pg_locale_t locale)
static int	pg_strncoll_libc (const char *arg1, size_t len1, const char *arg2, size_t len2, pg_locale_t locale)
int	pg_strcoll (const char *arg1, const char *arg2, pg_locale_t locale)
int	pg_strncoll (const char *arg1, size_t len1, const char *arg2, size_t len2, pg_locale_t locale)
static size_t	pg_strxfrm_libc (char *dest, const char *src, size_t destsize, pg_locale_t locale)
static size_t	pg_strnxfrm_libc (char *dest, const char *src, size_t srclen, size_t destsize, pg_locale_t locale)
bool	pg_strxfrm_enabled (pg_locale_t locale)
size_t	pg_strxfrm (char *dest, const char *src, size_t destsize, pg_locale_t locale)
size_t	pg_strnxfrm (char *dest, size_t destsize, const char *src, size_t srclen, pg_locale_t locale)
bool	pg_strxfrm_prefix_enabled (pg_locale_t locale)
size_t	pg_strxfrm_prefix (char *dest, const char *src, size_t destsize, pg_locale_t locale)
size_t	pg_strnxfrm_prefix (char *dest, size_t destsize, const char *src, size_t srclen, pg_locale_t locale)
void	check_icu_locale (const char *icu_locale)
size_t	wchar2char (char *to, const wchar_t *from, size_t tolen, pg_locale_t locale)
size_t	char2wchar (wchar_t *to, size_t tolen, const char *from, size_t fromlen, pg_locale_t locale)

Variables
char *	locale_messages
char *	locale_monetary
char *	locale_numeric
char *	locale_time
char *	localized_abbrev_days [7+1]
char *	localized_full_days [7+1]
char *	localized_abbrev_months [12+1]
char *	localized_full_months [12+1]
bool	database_ctype_is_c = false
static bool	CurrentLocaleConvValid = false
static bool	CurrentLCTimeValid = false
static HTAB *	collation_cache = NULL
struct pg_locale_struct	default_locale

Macro Definition Documentation

MAX_L10N_DATA

#define MAX_L10N_DATA   80

Definition at line 89 of file pg_locale.c.

TEXTBUFLEN

#define TEXTBUFLEN   1024

Definition at line 87 of file pg_locale.c.

Function Documentation

assign_locale_messages()

void assign_locale_messages	(	const char *	newval,
		void *	extra
	)

Definition at line 382 of file pg_locale.c.

{
    /*
     * LC_MESSAGES category does not exist everywhere, but accept it anyway.
     * We ignore failure, as per comment above.
     */
#ifdef LC_MESSAGES
    (void) pg_perm_setlocale(LC_MESSAGES, newval);
#endif
}

References newval, and pg_perm_setlocale().

assign_locale_monetary()

void assign_locale_monetary	(	const char *	newval,
		void *	extra
	)

Definition at line 319 of file pg_locale.c.

{
    CurrentLocaleConvValid = false;
}

References CurrentLocaleConvValid.

assign_locale_numeric()

void assign_locale_numeric	(	const char *	newval,
		void *	extra
	)

Definition at line 331 of file pg_locale.c.

{
    CurrentLocaleConvValid = false;
}

References CurrentLocaleConvValid.

assign_locale_time()

void assign_locale_time	(	const char *	newval,
		void *	extra
	)

Definition at line 343 of file pg_locale.c.

{
    CurrentLCTimeValid = false;
}

References CurrentLCTimeValid.

cache_locale_time()

void cache_locale_time

(

void

)

Definition at line 761 of file pg_locale.c.

{
    char        buf[(2 * 7 + 2 * 12) * MAX_L10N_DATA];
    char       *bufptr;
    time_t      timenow;
    struct tm  *timeinfo;
    bool        strftimefail = false;
    int         encoding;
    int         i;
    char       *save_lc_time;
#ifdef WIN32
    char       *save_lc_ctype;
#endif
 
    /* did we do this already? */
    if (CurrentLCTimeValid)
        return;
 
    elog(DEBUG3, "cache_locale_time() executed; locale: \"%s\"", locale_time);
 
    /*
     * As in PGLC_localeconv(), it's critical that we not throw error while
     * libc's locale settings have nondefault values.  Hence, we just call
     * strftime() within the critical section, and then convert and save its
     * results afterwards.
     */
 
    /* Save prevailing value of time locale */
    save_lc_time = setlocale(LC_TIME, NULL);
    if (!save_lc_time)
        elog(ERROR, "setlocale(NULL) failed");
    save_lc_time = pstrdup(save_lc_time);
 
#ifdef WIN32
 
    /*
     * On Windows, it appears that wcsftime() internally uses LC_CTYPE, so we
     * must set it here.  This code looks the same as what PGLC_localeconv()
     * does, but the underlying reason is different: this does NOT determine
     * the encoding we'll get back from strftime_win32().
     */
 
    /* Save prevailing value of ctype locale */
    save_lc_ctype = setlocale(LC_CTYPE, NULL);
    if (!save_lc_ctype)
        elog(ERROR, "setlocale(NULL) failed");
    save_lc_ctype = pstrdup(save_lc_ctype);
 
    /* use lc_time to set the ctype */
    setlocale(LC_CTYPE, locale_time);
#endif
 
    setlocale(LC_TIME, locale_time);
 
    /* We use times close to current time as data for strftime(). */
    timenow = time(NULL);
    timeinfo = localtime(&timenow);
 
    /* Store the strftime results in MAX_L10N_DATA-sized portions of buf[] */
    bufptr = buf;
 
    /*
     * MAX_L10N_DATA is sufficient buffer space for every known locale, and
     * POSIX defines no strftime() errors.  (Buffer space exhaustion is not an
     * error.)  An implementation might report errors (e.g. ENOMEM) by
     * returning 0 (or, less plausibly, a negative value) and setting errno.
     * Report errno just in case the implementation did that, but clear it in
     * advance of the calls so we don't emit a stale, unrelated errno.
     */
    errno = 0;
 
    /* localized days */
    for (i = 0; i < 7; i++)
    {
        timeinfo->tm_wday = i;
        if (strftime(bufptr, MAX_L10N_DATA, "%a", timeinfo) <= 0)
            strftimefail = true;
        bufptr += MAX_L10N_DATA;
        if (strftime(bufptr, MAX_L10N_DATA, "%A", timeinfo) <= 0)
            strftimefail = true;
        bufptr += MAX_L10N_DATA;
    }
 
    /* localized months */
    for (i = 0; i < 12; i++)
    {
        timeinfo->tm_mon = i;
        timeinfo->tm_mday = 1;  /* make sure we don't have invalid date */
        if (strftime(bufptr, MAX_L10N_DATA, "%b", timeinfo) <= 0)
            strftimefail = true;
        bufptr += MAX_L10N_DATA;
        if (strftime(bufptr, MAX_L10N_DATA, "%B", timeinfo) <= 0)
            strftimefail = true;
        bufptr += MAX_L10N_DATA;
    }
 
    /*
     * Restore the prevailing locale settings; as in PGLC_localeconv(),
     * failure to do so is fatal.
     */
#ifdef WIN32
    if (!setlocale(LC_CTYPE, save_lc_ctype))
        elog(FATAL, "failed to restore LC_CTYPE to \"%s\"", save_lc_ctype);
#endif
    if (!setlocale(LC_TIME, save_lc_time))
        elog(FATAL, "failed to restore LC_TIME to \"%s\"", save_lc_time);
 
    /*
     * At this point we've done our best to clean up, and can throw errors, or
     * call functions that might throw errors, with a clean conscience.
     */
    if (strftimefail)
        elog(ERROR, "strftime() failed: %m");
 
    /* Release the pstrdup'd locale names */
    pfree(save_lc_time);
#ifdef WIN32
    pfree(save_lc_ctype);
#endif
 
#ifndef WIN32
 
    /*
     * As in PGLC_localeconv(), we must convert strftime()'s output from the
     * encoding implied by LC_TIME to the database encoding.  If we can't
     * identify the LC_TIME encoding, just perform encoding validation.
     */
    encoding = pg_get_encoding_from_locale(locale_time, true);
    if (encoding < 0)
        encoding = PG_SQL_ASCII;
 
#else
 
    /*
     * On Windows, strftime_win32() always returns UTF8 data, so convert from
     * that if necessary.
     */
    encoding = PG_UTF8;
 
#endif                          /* WIN32 */
 
    bufptr = buf;
 
    /* localized days */
    for (i = 0; i < 7; i++)
    {
        cache_single_string(&localized_abbrev_days[i], bufptr, encoding);
        bufptr += MAX_L10N_DATA;
        cache_single_string(&localized_full_days[i], bufptr, encoding);
        bufptr += MAX_L10N_DATA;
    }
    localized_abbrev_days[7] = NULL;
    localized_full_days[7] = NULL;
 
    /* localized months */
    for (i = 0; i < 12; i++)
    {
        cache_single_string(&localized_abbrev_months[i], bufptr, encoding);
        bufptr += MAX_L10N_DATA;
        cache_single_string(&localized_full_months[i], bufptr, encoding);
        bufptr += MAX_L10N_DATA;
    }
    localized_abbrev_months[12] = NULL;
    localized_full_months[12] = NULL;
 
    CurrentLCTimeValid = true;
}

References buf, cache_single_string(), CurrentLCTimeValid, DEBUG3, elog(), encoding, ERROR, FATAL, i, locale_time, localized_abbrev_days, localized_abbrev_months, localized_full_days, localized_full_months, MAX_L10N_DATA, pfree(), pg_get_encoding_from_locale(), PG_SQL_ASCII, PG_UTF8, pstrdup(), setlocale, and tm.

Referenced by DCH_from_char(), and DCH_to_char().

cache_single_string()

static void cache_single_string ( char **  dst, const char *  src, int  encoding  )

static

Definition at line 738 of file pg_locale.c.

{
    char       *ptr;
    char       *olddst;
 
    /* Convert the string to the database encoding, or validate it's OK */
    ptr = pg_any_to_server(src, strlen(src), encoding);
 
    /* Store the string in long-lived storage, replacing any previous value */
    olddst = *dst;
    *dst = MemoryContextStrdup(TopMemoryContext, ptr);
    if (olddst)
        pfree(olddst);
 
    /* Might as well clean up any palloc'd conversion result, too */
    if (ptr != src)
        pfree(ptr);
}

References encoding, MemoryContextStrdup(), pfree(), pg_any_to_server(), and TopMemoryContext.

Referenced by cache_locale_time().

char2wchar()

size_t char2wchar	(	wchar_t *	to,
		size_t	tolen,
		const char *	from,
		size_t	fromlen,
		pg_locale_t	locale
	)

Definition at line 2877 of file pg_locale.c.

{
    size_t      result;
 
    Assert(!locale || locale->provider == COLLPROVIDER_LIBC);
 
    if (tolen == 0)
        return 0;
 
#ifdef WIN32
    /* See WIN32 "Unicode" comment above */
    if (GetDatabaseEncoding() == PG_UTF8)
    {
        /* Win32 API does not work for zero-length input */
        if (fromlen == 0)
            result = 0;
        else
        {
            result = MultiByteToWideChar(CP_UTF8, 0, from, fromlen, to, tolen - 1);
            /* A zero return is failure */
            if (result == 0)
                result = -1;
        }
 
        if (result != -1)
        {
            Assert(result < tolen);
            /* Append trailing null wchar (MultiByteToWideChar() does not) */
            to[result] = 0;
        }
    }
    else
#endif                          /* WIN32 */
    {
        /* mbstowcs requires ending '\0' */
        char       *str = pnstrdup(from, fromlen);
 
        if (locale == (pg_locale_t) 0)
        {
            /* Use mbstowcs directly for the default locale */
            result = mbstowcs(to, str, tolen);
        }
        else
        {
#ifdef HAVE_LOCALE_T
#ifdef HAVE_MBSTOWCS_L
            /* Use mbstowcs_l for nondefault locales */
            result = mbstowcs_l(to, str, tolen, locale->info.lt);
#else                           /* !HAVE_MBSTOWCS_L */
            /* We have to temporarily set the locale as current ... ugh */
            locale_t    save_locale = uselocale(locale->info.lt);
 
            result = mbstowcs(to, str, tolen);
 
            uselocale(save_locale);
#endif                          /* HAVE_MBSTOWCS_L */
#else                           /* !HAVE_LOCALE_T */
            /* Can't have locale != 0 without HAVE_LOCALE_T */
            elog(ERROR, "mbstowcs_l is not available");
            result = 0;         /* keep compiler quiet */
#endif                          /* HAVE_LOCALE_T */
        }
 
        pfree(str);
    }
 
    if (result == -1)
    {
        /*
         * Invalid multibyte character encountered.  We try to give a useful
         * error message by letting pg_verifymbstr check the string.  But it's
         * possible that the string is OK to us, and not OK to mbstowcs ---
         * this suggests that the LC_CTYPE locale is different from the
         * database encoding.  Give a generic error message if pg_verifymbstr
         * can't find anything wrong.
         */
        pg_verifymbstr(from, fromlen, false);   /* might not return */
        /* but if it does ... */
        ereport(ERROR,
                (errcode(ERRCODE_CHARACTER_NOT_IN_REPERTOIRE),
                 errmsg("invalid multibyte character for locale"),
                 errhint("The server's LC_CTYPE locale is probably incompatible with the database encoding.")));
    }
 
    return result;
}

References Assert(), elog(), ereport, errcode(), errhint(), errmsg(), ERROR, GetDatabaseEncoding(), locale, locale_t, mbstowcs_l, pfree(), PG_UTF8, pg_verifymbstr(), pnstrdup(), and generate_unaccent_rules::str.

Referenced by lowerstr_with_len(), str_initcap(), str_tolower(), str_toupper(), t_isalnum(), t_isalpha(), t_isdigit(), t_isprint(), t_isspace(), and TParserInit().

check_icu_locale()

void check_icu_locale

(

const char *

icu_locale

)

Definition at line 2770 of file pg_locale.c.

{
#ifdef USE_ICU
    UCollator  *collator;
    UErrorCode  status;
 
    status = U_ZERO_ERROR;
    collator = ucol_open(icu_locale, &status);
    if (U_FAILURE(status))
        ereport(ERROR,
                (errmsg("could not open collator for locale \"%s\": %s",
                        icu_locale, u_errorName(status))));
 
    if (U_ICU_VERSION_MAJOR_NUM < 54)
        icu_set_collation_attributes(collator, icu_locale);
    ucol_close(collator);
#else
    ereport(ERROR,
            (errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
             errmsg("ICU is not supported in this build")));
#endif
}

References ereport, errcode(), errmsg(), ERROR, icu_locale, and status().

Referenced by createdb().

check_locale()

bool check_locale	(	int	category,
		const char *	locale,
		char **	canonname
	)

Definition at line 270 of file pg_locale.c.

{
    char       *save;
    char       *res;
 
    if (canonname)
        *canonname = NULL;      /* in case of failure */
 
    save = setlocale(category, NULL);
    if (!save)
        return false;           /* won't happen, we hope */
 
    /* save may be pointing at a modifiable scratch variable, see above. */
    save = pstrdup(save);
 
    /* set the locale with setlocale, to see if it accepts it. */
    res = setlocale(category, locale);
 
    /* save canonical name if requested. */
    if (res && canonname)
        *canonname = pstrdup(res);
 
    /* restore old value. */
    if (!setlocale(category, save))
        elog(WARNING, "failed to restore old locale \"%s\"", save);
    pfree(save);
 
    return (res != NULL);
}

References elog(), locale, pfree(), pstrdup(), res, setlocale, and WARNING.

Referenced by check_locale_messages(), check_locale_monetary(), check_locale_numeric(), check_locale_time(), and createdb().

check_locale_messages()

bool check_locale_messages	(	char **	newval,
		void **	extra,
		GucSource	source
	)

Definition at line 359 of file pg_locale.c.

{
    if (**newval == '\0')
    {
        if (source == PGC_S_DEFAULT)
            return true;
        else
            return false;
    }
 
    /*
     * LC_MESSAGES category does not exist everywhere, but accept it anyway
     *
     * On Windows, we can't even check the value, so accept blindly
     */
#if defined(LC_MESSAGES) && !defined(WIN32)
    return check_locale(LC_MESSAGES, *newval, NULL);
#else
    return true;
#endif
}

References check_locale(), newval, PGC_S_DEFAULT, and source.

check_locale_monetary()

bool check_locale_monetary	(	char **	newval,
		void **	extra,
		GucSource	source
	)

Definition at line 313 of file pg_locale.c.

{
    return check_locale(LC_MONETARY, *newval, NULL);
}

References check_locale(), and newval.

check_locale_numeric()

bool check_locale_numeric	(	char **	newval,
		void **	extra,
		GucSource	source
	)

Definition at line 325 of file pg_locale.c.

{
    return check_locale(LC_NUMERIC, *newval, NULL);
}

References check_locale(), and newval.

check_locale_time()

bool check_locale_time	(	char **	newval,
		void **	extra,
		GucSource	source
	)

Definition at line 337 of file pg_locale.c.

{
    return check_locale(LC_TIME, *newval, NULL);
}

References check_locale(), and newval.

check_strxfrm_bug()

void check_strxfrm_bug

(

void

)

Definition at line 1173 of file pg_locale.c.

{
    char        buf[32];
    const int   canary = 0x7F;
    bool        ok = true;
 
    /*
     * Given a two-byte ASCII string and length limit 7, 8 or 9, Solaris 10
     * 05/08 returns 18 and modifies 10 bytes.  It respects limits above or
     * below that range.
     *
     * The bug is present in Solaris 8 as well; it is absent in Solaris 10
     * 01/13 and Solaris 11.2.  Affected locales include is_IS.ISO8859-1,
     * en_US.UTF-8, en_US.ISO8859-1, and ru_RU.KOI8-R.  Unaffected locales
     * include de_DE.UTF-8, de_DE.ISO8859-1, zh_TW.UTF-8, and C.
     */
    buf[7] = canary;
    (void) strxfrm(buf, "ab", 7);
    if (buf[7] != canary)
        ok = false;
 
    /*
     * illumos bug #1594 was present in the source tree from 2010-10-11 to
     * 2012-02-01.  Given an ASCII string of any length and length limit 1,
     * affected systems ignore the length limit and modify a number of bytes
     * one less than the return value.  The problem inputs for this bug do not
     * overlap those for the Solaris bug, hence a distinct test.
     *
     * Affected systems include smartos-20110926T021612Z.  Affected locales
     * include en_US.ISO8859-1 and en_US.UTF-8.  Unaffected locales include C.
     */
    buf[1] = canary;
    (void) strxfrm(buf, "a", 1);
    if (buf[1] != canary)
        ok = false;
 
    if (!ok)
        ereport(ERROR,
                (errcode(ERRCODE_SYSTEM_ERROR),
                 errmsg_internal("strxfrm(), in locale \"%s\", writes past the specified array length",
                                 setlocale(LC_COLLATE, NULL)),
                 errhint("Apply system library package updates.")));
}

References buf, ereport, errcode(), errhint(), errmsg_internal(), ERROR, and setlocale.

Referenced by CheckMyDatabase(), and main().

db_encoding_convert()

static void db_encoding_convert ( int  encoding, char **  str  )

static

Definition at line 449 of file pg_locale.c.

{
    char       *pstr;
    char       *mstr;
 
    /* convert the string to the database encoding */
    pstr = pg_any_to_server(*str, strlen(*str), encoding);
    if (pstr == *str)
        return;                 /* no conversion happened */
 
    /* need it malloc'd not palloc'd */
    mstr = strdup(pstr);
    if (mstr == NULL)
        ereport(ERROR,
                (errcode(ERRCODE_OUT_OF_MEMORY),
                 errmsg("out of memory")));
 
    /* replace old string */
    free(*str);
    *str = mstr;
 
    pfree(pstr);
}

References encoding, ereport, errcode(), errmsg(), ERROR, free, pfree(), pg_any_to_server(), and generate_unaccent_rules::str.

Referenced by PGLC_localeconv().

free_struct_lconv()

static void free_struct_lconv ( struct lconv *  s )

static

Definition at line 399 of file pg_locale.c.

{
    free(s->decimal_point);
    free(s->thousands_sep);
    free(s->grouping);
    free(s->int_curr_symbol);
    free(s->currency_symbol);
    free(s->mon_decimal_point);
    free(s->mon_thousands_sep);
    free(s->mon_grouping);
    free(s->positive_sign);
    free(s->negative_sign);
}

References free.

Referenced by PGLC_localeconv().

get_collation_actual_version()

char* get_collation_actual_version	(	char	collprovider,
		const char *	collcollate
	)

Definition at line 1717 of file pg_locale.c.

{
    char       *collversion = NULL;
 
#ifdef USE_ICU
    if (collprovider == COLLPROVIDER_ICU)
    {
        UCollator  *collator;
        UErrorCode  status;
        UVersionInfo versioninfo;
        char        buf[U_MAX_VERSION_STRING_LENGTH];
 
        status = U_ZERO_ERROR;
        collator = ucol_open(collcollate, &status);
        if (U_FAILURE(status))
            ereport(ERROR,
                    (errmsg("could not open collator for locale \"%s\": %s",
                            collcollate, u_errorName(status))));
        ucol_getVersion(collator, versioninfo);
        ucol_close(collator);
 
        u_versionToString(versioninfo, buf);
        collversion = pstrdup(buf);
    }
    else
#endif
        if (collprovider == COLLPROVIDER_LIBC &&
            pg_strcasecmp("C", collcollate) != 0 &&
            pg_strncasecmp("C.", collcollate, 2) != 0 &&
            pg_strcasecmp("POSIX", collcollate) != 0)
    {
#if defined(__GLIBC__)
        /* Use the glibc version because we don't have anything better. */
        collversion = pstrdup(gnu_get_libc_version());
#elif defined(LC_VERSION_MASK)
        locale_t    loc;
 
        /* Look up FreeBSD collation version. */
        loc = newlocale(LC_COLLATE, collcollate, NULL);
        if (loc)
        {
            collversion =
                pstrdup(querylocale(LC_COLLATE_MASK | LC_VERSION_MASK, loc));
            freelocale(loc);
        }
        else
            ereport(ERROR,
                    (errmsg("could not load locale \"%s\"", collcollate)));
#elif defined(WIN32)
        /*
         * If we are targeting Windows Vista and above, we can ask for a name
         * given a collation name (earlier versions required a location code
         * that we don't have).
         */
        NLSVERSIONINFOEX version = {sizeof(NLSVERSIONINFOEX)};
        WCHAR       wide_collcollate[LOCALE_NAME_MAX_LENGTH];
 
        MultiByteToWideChar(CP_ACP, 0, collcollate, -1, wide_collcollate,
                            LOCALE_NAME_MAX_LENGTH);
        if (!GetNLSVersionEx(COMPARE_STRING, wide_collcollate, &version))
        {
            /*
             * GetNLSVersionEx() wants a language tag such as "en-US", not a
             * locale name like "English_United States.1252".  Until those
             * values can be prevented from entering the system, or 100%
             * reliably converted to the more useful tag format, tolerate the
             * resulting error and report that we have no version data.
             */
            if (GetLastError() == ERROR_INVALID_PARAMETER)
                return NULL;
 
            ereport(ERROR,
                    (errmsg("could not get collation version for locale \"%s\": error code %lu",
                            collcollate,
                            GetLastError())));
        }
        collversion = psprintf("%ld.%ld,%ld.%ld",
                               (version.dwNLSVersion >> 8) & 0xFFFF,
                               version.dwNLSVersion & 0xFF,
                               (version.dwDefinedVersion >> 8) & 0xFFFF,
                               version.dwDefinedVersion & 0xFF);
#endif
    }
 
    return collversion;
}

References buf, ereport, errmsg(), ERROR, locale_t, pg_strcasecmp(), pg_strncasecmp(), psprintf(), pstrdup(), and status().

Referenced by AlterCollation(), AlterDatabaseRefreshColl(), CheckMyDatabase(), createdb(), DefineCollation(), pg_collation_actual_version(), pg_database_collation_actual_version(), pg_import_system_collations(), and pg_newlocale_from_collation().

lc_collate_is_c()

bool lc_collate_is_c

(

Oid

collation

)

Definition at line 1322 of file pg_locale.c.

{
    /*
     * If we're asked about "collation 0", return false, so that the code will
     * go into the non-C path and report that the collation is bogus.
     */
    if (!OidIsValid(collation))
        return false;
 
    /*
     * If we're asked about the default collation, we have to inquire of the C
     * library.  Cache the result so we only have to compute it once.
     */
    if (collation == DEFAULT_COLLATION_OID)
    {
        static int  result = -1;
        char       *localeptr;
 
        if (default_locale.provider == COLLPROVIDER_ICU)
            return false;
 
        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;
    }
 
    /*
     * If we're asked about the built-in C/POSIX collations, we know that.
     */
    if (collation == C_COLLATION_OID ||
        collation == POSIX_COLLATION_OID)
        return true;
 
    /*
     * Otherwise, we have to consult pg_collation, but we cache that.
     */
    return (lookup_collation_cache(collation, true))->collate_is_c;
}

References default_locale, elog(), ERROR, lookup_collation_cache(), OidIsValid, pg_locale_struct::provider, and setlocale.

Referenced by bpchareq(), bpcharne(), btvarstrequalimage(), convert_string_datum(), DefineCollation(), hashbpchar(), hashbpcharextended(), hashtext(), hashtextextended(), make_greater_string(), match_pattern_prefix(), spg_text_inner_consistent(), text_position_setup(), text_starts_with(), texteq(), textne(), varstr_cmp(), and varstr_sortsupport().

lc_ctype_is_c()

bool lc_ctype_is_c

(

Oid

collation

)

Definition at line 1375 of file pg_locale.c.

{
    /*
     * If we're asked about "collation 0", return false, so that the code will
     * go into the non-C path and report that the collation is bogus.
     */
    if (!OidIsValid(collation))
        return false;
 
    /*
     * If we're asked about the default collation, we have to inquire of the C
     * library.  Cache the result so we only have to compute it once.
     */
    if (collation == DEFAULT_COLLATION_OID)
    {
        static int  result = -1;
        char       *localeptr;
 
        if (default_locale.provider == COLLPROVIDER_ICU)
            return false;
 
        if (result >= 0)
            return (bool) result;
        localeptr = setlocale(LC_CTYPE, NULL);
        if (!localeptr)
            elog(ERROR, "invalid LC_CTYPE setting");
 
        if (strcmp(localeptr, "C") == 0)
            result = true;
        else if (strcmp(localeptr, "POSIX") == 0)
            result = true;
        else
            result = false;
        return (bool) result;
    }
 
    /*
     * If we're asked about the built-in C/POSIX collations, we know that.
     */
    if (collation == C_COLLATION_OID ||
        collation == POSIX_COLLATION_OID)
        return true;
 
    /*
     * Otherwise, we have to consult pg_collation, but we cache that.
     */
    return (lookup_collation_cache(collation, true))->ctype_is_c;
}

Referenced by DefineCollation(), Generic_Text_IC_like(), GenericMatchText(), like_fixed_prefix(), pg_set_regex_collation(), str_initcap(), str_tolower(), and str_toupper().

lookup_collation_cache()

static collation_cache_entry* lookup_collation_cache ( Oid  collation, bool  set_flags  )

static

Definition at line 1243 of file pg_locale.c.

{
    collation_cache_entry *cache_entry;
    bool        found;
 
    Assert(OidIsValid(collation));
    Assert(collation != DEFAULT_COLLATION_OID);
 
    if (collation_cache == NULL)
    {
        /* First time through, initialize the hash table */
        HASHCTL     ctl;
 
        ctl.keysize = sizeof(Oid);
        ctl.entrysize = sizeof(collation_cache_entry);
        collation_cache = hash_create("Collation cache", 100, &ctl,
                                      HASH_ELEM | HASH_BLOBS);
    }
 
    cache_entry = hash_search(collation_cache, &collation, HASH_ENTER, &found);
    if (!found)
    {
        /*
         * Make sure cache entry is marked invalid, in case we fail before
         * setting things.
         */
        cache_entry->flags_valid = false;
        cache_entry->locale = 0;
    }
 
    if (set_flags && !cache_entry->flags_valid)
    {
        /* Attempt to set the flags */
        HeapTuple   tp;
        Form_pg_collation collform;
 
        tp = SearchSysCache1(COLLOID, ObjectIdGetDatum(collation));
        if (!HeapTupleIsValid(tp))
            elog(ERROR, "cache lookup failed for collation %u", collation);
        collform = (Form_pg_collation) GETSTRUCT(tp);
 
        if (collform->collprovider == COLLPROVIDER_LIBC)
        {
            Datum       datum;
            bool        isnull;
            const char *collcollate;
            const char *collctype;
 
            datum = SysCacheGetAttr(COLLOID, tp, Anum_pg_collation_collcollate, &isnull);
            Assert(!isnull);
            collcollate = TextDatumGetCString(datum);
            datum = SysCacheGetAttr(COLLOID, tp, Anum_pg_collation_collctype, &isnull);
            Assert(!isnull);
            collctype = TextDatumGetCString(datum);
 
            cache_entry->collate_is_c = ((strcmp(collcollate, "C") == 0) ||
                                         (strcmp(collcollate, "POSIX") == 0));
            cache_entry->ctype_is_c = ((strcmp(collctype, "C") == 0) ||
                                       (strcmp(collctype, "POSIX") == 0));
        }
        else
        {
            cache_entry->collate_is_c = false;
            cache_entry->ctype_is_c = false;
        }
 
        cache_entry->flags_valid = true;
 
        ReleaseSysCache(tp);
    }
 
    return cache_entry;
}

References Assert(), collation_cache_entry::collate_is_c, collation_cache, COLLOID, collation_cache_entry::ctype_is_c, elog(), HASHCTL::entrysize, ERROR, collation_cache_entry::flags_valid, GETSTRUCT, HASH_BLOBS, hash_create(), HASH_ELEM, HASH_ENTER, hash_search(), HeapTupleIsValid, HASHCTL::keysize, collation_cache_entry::locale, ObjectIdGetDatum(), OidIsValid, ReleaseSysCache(), SearchSysCache1(), SysCacheGetAttr(), and TextDatumGetCString.

Referenced by lc_collate_is_c(), and pg_newlocale_from_collation().

make_icu_collator()

void make_icu_collator	(	const char *	iculocstr,
		const char *	icurules,
		struct pg_locale_struct *	resultp
	)

Definition at line 1427 of file pg_locale.c.

{
#ifdef USE_ICU
    UCollator  *collator;
    UErrorCode  status;
 
    status = U_ZERO_ERROR;
    collator = ucol_open(iculocstr, &status);
    if (U_FAILURE(status))
        ereport(ERROR,
                (errmsg("could not open collator for locale \"%s\": %s",
                        iculocstr, u_errorName(status))));
 
    if (U_ICU_VERSION_MAJOR_NUM < 54)
        icu_set_collation_attributes(collator, iculocstr);
 
    /*
     * If rules are specified, we extract the rules of the standard collation,
     * add our own rules, and make a new collator with the combined rules.
     */
    if (icurules)
    {
        const UChar *default_rules;
        UChar      *agg_rules;
        UChar      *my_rules;
        int32_t     length;
 
        default_rules = ucol_getRules(collator, &length);
        icu_to_uchar(&my_rules, icurules, strlen(icurules));
 
        agg_rules = palloc_array(UChar, u_strlen(default_rules) + u_strlen(my_rules) + 1);
        u_strcpy(agg_rules, default_rules);
        u_strcat(agg_rules, my_rules);
 
        ucol_close(collator);
 
        status = U_ZERO_ERROR;
        collator = ucol_openRules(agg_rules, u_strlen(agg_rules),
                                  UCOL_DEFAULT, UCOL_DEFAULT_STRENGTH, NULL, &status);
        if (U_FAILURE(status))
            ereport(ERROR,
                    (errmsg("could not open collator for locale \"%s\" with rules \"%s\": %s",
                            iculocstr, icurules, u_errorName(status))));
    }
 
    /* We will leak this string if the caller errors later :-( */
    resultp->info.icu.locale = MemoryContextStrdup(TopMemoryContext, iculocstr);
    resultp->info.icu.ucol = collator;
#else                           /* not USE_ICU */
    /* could get here if a collation was created by a build with ICU */
    ereport(ERROR,
            (errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
             errmsg("ICU is not supported in this build")));
#endif                          /* not USE_ICU */
}

References ereport, errcode(), errmsg(), ERROR, pg_locale_struct::info, MemoryContextStrdup(), palloc_array, status(), and TopMemoryContext.

Referenced by CheckMyDatabase(), and pg_newlocale_from_collation().

pg_locale_deterministic()

bool pg_locale_deterministic

(

pg_locale_t

locale

)

Definition at line 1519 of file pg_locale.c.

{
    /* default locale must always be deterministic */
    if (locale == NULL)
        return true;
    else
        return locale->deterministic;
}

References locale.

Referenced by bpchareq(), bpcharne(), Generic_Text_IC_like(), GenericMatchText(), hashbpchar(), hashbpcharextended(), hashtext(), hashtextextended(), pg_set_regex_collation(), text_position_setup(), text_starts_with(), texteq(), textne(), varstr_cmp(), and varstrfastcmp_locale().

pg_newlocale_from_collation()

pg_locale_t pg_newlocale_from_collation

(

Oid

collid

)

Definition at line 1543 of file pg_locale.c.

{
    collation_cache_entry *cache_entry;
 
    /* Callers must pass a valid OID */
    Assert(OidIsValid(collid));
 
    if (collid == DEFAULT_COLLATION_OID)
    {
        if (default_locale.provider == COLLPROVIDER_ICU)
            return &default_locale;
        else
            return (pg_locale_t) 0;
    }
 
    cache_entry = lookup_collation_cache(collid, false);
 
    if (cache_entry->locale == 0)
    {
        /* We haven't computed this yet in this session, so do it */
        HeapTuple   tp;
        Form_pg_collation collform;
        struct pg_locale_struct result;
        pg_locale_t resultp;
        Datum       datum;
        bool        isnull;
 
        tp = SearchSysCache1(COLLOID, ObjectIdGetDatum(collid));
        if (!HeapTupleIsValid(tp))
            elog(ERROR, "cache lookup failed for collation %u", collid);
        collform = (Form_pg_collation) GETSTRUCT(tp);
 
        /* We'll fill in the result struct locally before allocating memory */
        memset(&result, 0, sizeof(result));
        result.provider = collform->collprovider;
        result.deterministic = collform->collisdeterministic;
 
        if (collform->collprovider == COLLPROVIDER_LIBC)
        {
#ifdef HAVE_LOCALE_T
            const char *collcollate;
            const char *collctype pg_attribute_unused();
            locale_t    loc;
 
            datum = SysCacheGetAttr(COLLOID, tp, Anum_pg_collation_collcollate, &isnull);
            Assert(!isnull);
            collcollate = TextDatumGetCString(datum);
            datum = SysCacheGetAttr(COLLOID, tp, Anum_pg_collation_collctype, &isnull);
            Assert(!isnull);
            collctype = TextDatumGetCString(datum);
 
            if (strcmp(collcollate, collctype) == 0)
            {
                /* Normal case where they're the same */
                errno = 0;
#ifndef WIN32
                loc = newlocale(LC_COLLATE_MASK | LC_CTYPE_MASK, collcollate,
                                NULL);
#else
                loc = _create_locale(LC_ALL, collcollate);
#endif
                if (!loc)
                    report_newlocale_failure(collcollate);
            }
            else
            {
#ifndef WIN32
                /* We need two newlocale() steps */
                locale_t    loc1;
 
                errno = 0;
                loc1 = newlocale(LC_COLLATE_MASK, collcollate, NULL);
                if (!loc1)
                    report_newlocale_failure(collcollate);
                errno = 0;
                loc = newlocale(LC_CTYPE_MASK, collctype, loc1);
                if (!loc)
                    report_newlocale_failure(collctype);
#else
 
                /*
                 * XXX The _create_locale() API doesn't appear to support
                 * this. Could perhaps be worked around by changing
                 * pg_locale_t to contain two separate fields.
                 */
                ereport(ERROR,
                        (errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
                         errmsg("collations with different collate and ctype values are not supported on this platform")));
#endif
            }
 
            result.info.lt = loc;
#else                           /* not HAVE_LOCALE_T */
            /* platform that doesn't support locale_t */
            ereport(ERROR,
                    (errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
                     errmsg("collation provider LIBC is not supported on this platform")));
#endif                          /* not HAVE_LOCALE_T */
        }
        else if (collform->collprovider == COLLPROVIDER_ICU)
        {
            const char *iculocstr;
            const char *icurules;
 
            datum = SysCacheGetAttr(COLLOID, tp, Anum_pg_collation_colliculocale, &isnull);
            Assert(!isnull);
            iculocstr = TextDatumGetCString(datum);
 
            datum = SysCacheGetAttr(COLLOID, tp, Anum_pg_collation_collicurules, &isnull);
            if (!isnull)
                icurules = TextDatumGetCString(datum);
            else
                icurules = NULL;
 
            make_icu_collator(iculocstr, icurules, &result);
        }
 
        datum = SysCacheGetAttr(COLLOID, tp, Anum_pg_collation_collversion,
                                &isnull);
        if (!isnull)
        {
            char       *actual_versionstr;
            char       *collversionstr;
 
            collversionstr = TextDatumGetCString(datum);
 
            datum = SysCacheGetAttr(COLLOID, tp, collform->collprovider == COLLPROVIDER_ICU ? Anum_pg_collation_colliculocale : Anum_pg_collation_collcollate, &isnull);
            Assert(!isnull);
 
            actual_versionstr = get_collation_actual_version(collform->collprovider,
                                                             TextDatumGetCString(datum));
            if (!actual_versionstr)
            {
                /*
                 * This could happen when specifying a version in CREATE
                 * COLLATION but the provider does not support versioning, or
                 * manually creating a mess in the catalogs.
                 */
                ereport(ERROR,
                        (errmsg("collation \"%s\" has no actual version, but a version was recorded",
                                NameStr(collform->collname))));
            }
 
            if (strcmp(actual_versionstr, collversionstr) != 0)
                ereport(WARNING,
                        (errmsg("collation \"%s\" has version mismatch",
                                NameStr(collform->collname)),
                         errdetail("The collation in the database was created using version %s, "
                                   "but the operating system provides version %s.",
                                   collversionstr, actual_versionstr),
                         errhint("Rebuild all objects affected by this collation and run "
                                 "ALTER COLLATION %s REFRESH VERSION, "
                                 "or build PostgreSQL with the right library version.",
                                 quote_qualified_identifier(get_namespace_name(collform->collnamespace),
                                                            NameStr(collform->collname)))));
        }
 
        ReleaseSysCache(tp);
 
        /* We'll keep the pg_locale_t structures in TopMemoryContext */
        resultp = MemoryContextAlloc(TopMemoryContext, sizeof(*resultp));
        *resultp = result;
 
        cache_entry->locale = resultp;
    }
 
    return cache_entry->locale;
}

References Assert(), collid, COLLOID, default_locale, pg_locale_struct::deterministic, elog(), ereport, errcode(), errdetail(), errhint(), errmsg(), ERROR, get_collation_actual_version(), get_namespace_name(), GETSTRUCT, HeapTupleIsValid, pg_locale_struct::info, collation_cache_entry::locale, locale_t, lookup_collation_cache(), make_icu_collator(), MemoryContextAlloc(), NameStr, ObjectIdGetDatum(), OidIsValid, pg_attribute_unused, pg_locale_struct::provider, quote_qualified_identifier(), ReleaseSysCache(), SearchSysCache1(), SysCacheGetAttr(), TextDatumGetCString, TopMemoryContext, and WARNING.

Referenced by bpchareq(), bpcharne(), DefineCollation(), Generic_Text_IC_like(), GenericMatchText(), hashbpchar(), hashbpcharextended(), hashtext(), hashtextextended(), like_fixed_prefix(), pg_set_regex_collation(), str_initcap(), str_tolower(), str_toupper(), text_position_setup(), text_starts_with(), texteq(), textne(), varstr_cmp(), and varstr_sortsupport().

pg_perm_setlocale()

char* pg_perm_setlocale	(	int	category,
		const char *	locale
	)

Definition at line 167 of file pg_locale.c.

{
    char       *result;
    const char *envvar;
 
#ifndef WIN32
    result = setlocale(category, locale);
#else
 
    /*
     * On Windows, setlocale(LC_MESSAGES) does not work, so just assume that
     * the given value is good and set it in the environment variables. We
     * must ignore attempts to set to "", which means "keep using the old
     * environment value".
     */
#ifdef LC_MESSAGES
    if (category == LC_MESSAGES)
    {
        result = (char *) locale;
        if (locale == NULL || locale[0] == '\0')
            return result;
    }
    else
#endif
        result = setlocale(category, locale);
#endif                          /* WIN32 */
 
    if (result == NULL)
        return result;          /* fall out immediately on failure */
 
    /*
     * Use the right encoding in translated messages.  Under ENABLE_NLS, let
     * pg_bind_textdomain_codeset() figure it out.  Under !ENABLE_NLS, message
     * format strings are ASCII, but database-encoding strings may enter the
     * message via %s.  This makes the overall message encoding equal to the
     * database encoding.
     */
    if (category == LC_CTYPE)
    {
        static char save_lc_ctype[LOCALE_NAME_BUFLEN];
 
        /* copy setlocale() return value before callee invokes it again */
        strlcpy(save_lc_ctype, result, sizeof(save_lc_ctype));
        result = save_lc_ctype;
 
#ifdef ENABLE_NLS
        SetMessageEncoding(pg_bind_textdomain_codeset(textdomain(NULL)));
#else
        SetMessageEncoding(GetDatabaseEncoding());
#endif
    }
 
    switch (category)
    {
        case LC_COLLATE:
            envvar = "LC_COLLATE";
            break;
        case LC_CTYPE:
            envvar = "LC_CTYPE";
            break;
#ifdef LC_MESSAGES
        case LC_MESSAGES:
            envvar = "LC_MESSAGES";
#ifdef WIN32
            result = IsoLocaleName(locale);
            if (result == NULL)
                result = (char *) locale;
            elog(DEBUG3, "IsoLocaleName() executed; locale: \"%s\"", result);
#endif                          /* WIN32 */
            break;
#endif                          /* LC_MESSAGES */
        case LC_MONETARY:
            envvar = "LC_MONETARY";
            break;
        case LC_NUMERIC:
            envvar = "LC_NUMERIC";
            break;
        case LC_TIME:
            envvar = "LC_TIME";
            break;
        default:
            elog(FATAL, "unrecognized LC category: %d", category);
            return NULL;        /* keep compiler quiet */
    }
 
    if (setenv(envvar, result, 1) != 0)
        return NULL;
 
    return result;
}

References DEBUG3, elog(), FATAL, GetDatabaseEncoding(), locale, LOCALE_NAME_BUFLEN, setenv, setlocale, SetMessageEncoding(), and strlcpy().

Referenced by assign_locale_messages(), CheckMyDatabase(), and init_locale().

pg_strcoll()

int pg_strcoll	(	const char *	arg1,
		const char *	arg2,
		pg_locale_t	locale
	)

Definition at line 2080 of file pg_locale.c.

{
    int         result;
 
    if (!locale || locale->provider == COLLPROVIDER_LIBC)
        result = pg_strcoll_libc(arg1, arg2, locale);
#ifdef USE_ICU
    else if (locale->provider == COLLPROVIDER_ICU)
        result = pg_strncoll_icu(arg1, -1, arg2, -1, locale);
#endif
    else
        /* shouldn't happen */
        elog(ERROR, "unsupported collprovider: %c", locale->provider);
 
    return result;
}

References elog(), ERROR, locale, and pg_strcoll_libc().

Referenced by varstrfastcmp_locale().

pg_strcoll_libc()

static int pg_strcoll_libc ( const char *  arg1, const char *  arg2, pg_locale_t  locale  )

static

Definition at line 1892 of file pg_locale.c.

{
    int result;
 
    Assert(!locale || locale->provider == COLLPROVIDER_LIBC);
#ifdef WIN32
    if (GetDatabaseEncoding() == PG_UTF8)
    {
        size_t len1 = strlen(arg1);
        size_t len2 = strlen(arg2);
        result = pg_strncoll_libc_win32_utf8(arg1, len1, arg2, len2, locale);
    }
    else
#endif                          /* WIN32 */
    if (locale)
    {
#ifdef HAVE_LOCALE_T
        result = strcoll_l(arg1, arg2, locale->info.lt);
#else
        /* shouldn't happen */
        elog(ERROR, "unsupported collprovider: %c", locale->provider);
#endif
    }
    else
        result = strcoll(arg1, arg2);
 
    return result;
}

References Assert(), elog(), ERROR, GetDatabaseEncoding(), locale, PG_UTF8, and strcoll_l.

Referenced by pg_strcoll(), and pg_strncoll_libc().

pg_strncoll()

int pg_strncoll	(	const char *	arg1,
		size_t	len1,
		const char *	arg2,
		size_t	len2,
		pg_locale_t	locale
	)

Definition at line 2115 of file pg_locale.c.

{
    int      result;
 
    if (!locale || locale->provider == COLLPROVIDER_LIBC)
        result = pg_strncoll_libc(arg1, len1, arg2, len2, locale);
#ifdef USE_ICU
    else if (locale->provider == COLLPROVIDER_ICU)
        result = pg_strncoll_icu(arg1, len1, arg2, len2, locale);
#endif
    else
        /* shouldn't happen */
        elog(ERROR, "unsupported collprovider: %c", locale->provider);
 
    return result;
}

References elog(), ERROR, locale, and pg_strncoll_libc().

Referenced by varstr_cmp().

pg_strncoll_libc()

static int pg_strncoll_libc ( const char *  arg1, size_t  len1, const char *  arg2, size_t  len2, pg_locale_t  locale  )

static

Definition at line 1927 of file pg_locale.c.

{
    char     sbuf[TEXTBUFLEN];
    char    *buf      = sbuf;
    size_t   bufsize1 = len1 + 1;
    size_t   bufsize2 = len2 + 1;
    char    *arg1n;
    char    *arg2n;
    int      result;
 
    Assert(!locale || locale->provider == COLLPROVIDER_LIBC);
 
#ifdef WIN32
    /* check for this case before doing the work for nul-termination */
    if (GetDatabaseEncoding() == PG_UTF8)
        return pg_strncoll_libc_win32_utf8(arg1, len1, arg2, len2, locale);
#endif                          /* WIN32 */
 
    if (bufsize1 + bufsize2 > TEXTBUFLEN)
        buf = palloc(bufsize1 + bufsize2);
 
    arg1n = buf;
    arg2n = buf + bufsize1;
 
    /* nul-terminate arguments */
    memcpy(arg1n, arg1, len1);
    arg1n[len1] = '\0';
    memcpy(arg2n, arg2, len2);
    arg2n[len2] = '\0';
 
    result = pg_strcoll_libc(arg1n, arg2n, locale);
 
    if (buf != sbuf)
        pfree(buf);
 
    return result;
}

References Assert(), buf, GetDatabaseEncoding(), locale, palloc(), pfree(), pg_strcoll_libc(), PG_UTF8, and TEXTBUFLEN.

Referenced by pg_strncoll().

pg_strnxfrm()

size_t pg_strnxfrm	(	char *	dest,
		size_t	destsize,
		const char *	src,
		size_t	srclen,
		pg_locale_t	locale
	)

Definition at line 2401 of file pg_locale.c.

{
    size_t result = 0; /* keep compiler quiet */
 
    if (!locale || locale->provider == COLLPROVIDER_LIBC)
        result = pg_strnxfrm_libc(dest, src, srclen, destsize, locale);
#ifdef USE_ICU
    else if (locale->provider == COLLPROVIDER_ICU)
        result = pg_strnxfrm_icu(dest, src, srclen, destsize, locale);
#endif
    else
        /* shouldn't happen */
        elog(ERROR, "unsupported collprovider: %c", locale->provider);
 
    return result;
}

References generate_unaccent_rules::dest, elog(), ERROR, locale, and pg_strnxfrm_libc().

Referenced by hashbpchar(), hashbpcharextended(), hashtext(), and hashtextextended().

pg_strnxfrm_libc()

static size_t pg_strnxfrm_libc ( char *  dest, const char *  src, size_t  srclen, size_t  destsize, pg_locale_t  locale  )

static

Definition at line 2155 of file pg_locale.c.

{
    char     sbuf[TEXTBUFLEN];
    char    *buf     = sbuf;
    size_t   bufsize = srclen + 1;
    size_t   result;
 
    Assert(!locale || locale->provider == COLLPROVIDER_LIBC);
 
    if (bufsize > TEXTBUFLEN)
        buf = palloc(bufsize);
 
    /* nul-terminate arguments */
    memcpy(buf, src, srclen);
    buf[srclen] = '\0';
 
    result = pg_strxfrm_libc(dest, buf, destsize, locale);
 
    if (buf != sbuf)
        pfree(buf);
 
    /* if dest is defined, it should be nul-terminated */
    Assert(result >= destsize || dest[result] == '\0');
 
    return result;
}

References Assert(), buf, bufsize, generate_unaccent_rules::dest, locale, palloc(), pfree(), pg_strxfrm_libc(), and TEXTBUFLEN.

Referenced by pg_strnxfrm().

pg_strnxfrm_prefix()

size_t pg_strnxfrm_prefix	(	char *	dest,
		size_t	destsize,
		const char *	src,
		size_t	srclen,
		pg_locale_t	locale
	)

Definition at line 2488 of file pg_locale.c.

{
    size_t result = 0; /* keep compiler quiet */
 
    if (!locale || locale->provider == COLLPROVIDER_LIBC)
        elog(ERROR, "collprovider '%c' does not support pg_strnxfrm_prefix()",
             locale->provider);
#ifdef USE_ICU
    else if (locale->provider == COLLPROVIDER_ICU)
        result = pg_strnxfrm_prefix_icu(dest, src, -1, destsize, locale);
#endif
    else
        /* shouldn't happen */
        elog(ERROR, "unsupported collprovider: %c", locale->provider);
 
    return result;
}

References generate_unaccent_rules::dest, elog(), ERROR, and locale.

pg_strxfrm()

size_t pg_strxfrm	(	char *	dest,
		const char *	src,
		size_t	destsize,
		pg_locale_t	locale
	)

Definition at line 2365 of file pg_locale.c.

{
    size_t result = 0; /* keep compiler quiet */
 
    if (!locale || locale->provider == COLLPROVIDER_LIBC)
        result = pg_strxfrm_libc(dest, src, destsize, locale);
#ifdef USE_ICU
    else if (locale->provider == COLLPROVIDER_ICU)
        result = pg_strnxfrm_icu(dest, src, -1, destsize, locale);
#endif
    else
        /* shouldn't happen */
        elog(ERROR, "unsupported collprovider: %c", locale->provider);
 
    return result;
}

References generate_unaccent_rules::dest, elog(), ERROR, locale, and pg_strxfrm_libc().

Referenced by varstr_abbrev_convert().

pg_strxfrm_enabled()

bool pg_strxfrm_enabled

(

pg_locale_t

locale

)

Definition at line 2333 of file pg_locale.c.

{
    if (!locale || locale->provider == COLLPROVIDER_LIBC)
#ifdef TRUST_STRXFRM
        return true;
#else
        return false;
#endif
    else if (locale->provider == COLLPROVIDER_ICU)
        return true;
    else
        /* shouldn't happen */
        elog(ERROR, "unsupported collprovider: %c", locale->provider);
 
    return false; /* keep compiler quiet */
}

References elog(), ERROR, and locale.

Referenced by varstr_sortsupport().

pg_strxfrm_libc()

static size_t pg_strxfrm_libc ( char *  dest, const char *  src, size_t  destsize, pg_locale_t  locale  )

static

Definition at line 2135 of file pg_locale.c.

{
    Assert(!locale || locale->provider == COLLPROVIDER_LIBC);
 
#ifdef TRUST_STRXFRM
#ifdef HAVE_LOCALE_T
    if (locale)
        return strxfrm_l(dest, src, destsize, locale->info.lt);
    else
#endif
        return strxfrm(dest, src, destsize);
#else
    /* shouldn't happen */
    elog(ERROR, "unsupported collprovider: %c", locale->provider);
    return 0; /* keep compiler quiet */
#endif
}

References Assert(), generate_unaccent_rules::dest, elog(), ERROR, locale, and strxfrm_l.

Referenced by pg_strnxfrm_libc(), and pg_strxfrm().

pg_strxfrm_prefix()

size_t pg_strxfrm_prefix	(	char *	dest,
		const char *	src,
		size_t	destsize,
		pg_locale_t	locale
	)

Definition at line 2451 of file pg_locale.c.

{
    size_t result = 0; /* keep compiler quiet */
 
    if (!locale || locale->provider == COLLPROVIDER_LIBC)
        elog(ERROR, "collprovider '%c' does not support pg_strxfrm_prefix()",
             locale->provider);
#ifdef USE_ICU
    else if (locale->provider == COLLPROVIDER_ICU)
        result = pg_strnxfrm_prefix_icu(dest, src, -1, destsize, locale);
#endif
    else
        /* shouldn't happen */
        elog(ERROR, "unsupported collprovider: %c", locale->provider);
 
    return result;
}

References generate_unaccent_rules::dest, elog(), ERROR, and locale.

Referenced by varstr_abbrev_convert().

pg_strxfrm_prefix_enabled()

bool pg_strxfrm_prefix_enabled

(

pg_locale_t

locale

)

Definition at line 2424 of file pg_locale.c.

{
    if (!locale || locale->provider == COLLPROVIDER_LIBC)
        return false;
    else if (locale->provider == COLLPROVIDER_ICU)
        return true;
    else
        /* shouldn't happen */
        elog(ERROR, "unsupported collprovider: %c", locale->provider);
 
    return false; /* keep compiler quiet */
}

References elog(), ERROR, and locale.

Referenced by varstr_abbrev_convert().

PGLC_localeconv()

struct lconv* PGLC_localeconv

(

void

)

Definition at line 479 of file pg_locale.c.

{
    static struct lconv CurrentLocaleConv;
    static bool CurrentLocaleConvAllocated = false;
    struct lconv *extlconv;
    struct lconv worklconv;
    char       *save_lc_monetary;
    char       *save_lc_numeric;
#ifdef WIN32
    char       *save_lc_ctype;
#endif
 
    /* Did we do it already? */
    if (CurrentLocaleConvValid)
        return &CurrentLocaleConv;
 
    /* Free any already-allocated storage */
    if (CurrentLocaleConvAllocated)
    {
        free_struct_lconv(&CurrentLocaleConv);
        CurrentLocaleConvAllocated = false;
    }
 
    /*
     * This is tricky because we really don't want to risk throwing error
     * while the locale is set to other than our usual settings.  Therefore,
     * the process is: collect the usual settings, set locale to special
     * setting, copy relevant data into worklconv using strdup(), restore
     * normal settings, convert data to desired encoding, and finally stash
     * the collected data in CurrentLocaleConv.  This makes it safe if we
     * throw an error during encoding conversion or run out of memory anywhere
     * in the process.  All data pointed to by struct lconv members is
     * allocated with strdup, to avoid premature elog(ERROR) and to allow
     * using a single cleanup routine.
     */
    memset(&worklconv, 0, sizeof(worklconv));
 
    /* Save prevailing values of monetary and numeric locales */
    save_lc_monetary = setlocale(LC_MONETARY, NULL);
    if (!save_lc_monetary)
        elog(ERROR, "setlocale(NULL) failed");
    save_lc_monetary = pstrdup(save_lc_monetary);
 
    save_lc_numeric = setlocale(LC_NUMERIC, NULL);
    if (!save_lc_numeric)
        elog(ERROR, "setlocale(NULL) failed");
    save_lc_numeric = pstrdup(save_lc_numeric);
 
#ifdef WIN32
 
    /*
     * The POSIX standard explicitly says that it is undefined what happens if
     * LC_MONETARY or LC_NUMERIC imply an encoding (codeset) different from
     * that implied by LC_CTYPE.  In practice, all Unix-ish platforms seem to
     * believe that localeconv() should return strings that are encoded in the
     * codeset implied by the LC_MONETARY or LC_NUMERIC locale name.  Hence,
     * once we have successfully collected the localeconv() results, we will
     * convert them from that codeset to the desired server encoding.
     *
     * Windows, of course, resolutely does things its own way; on that
     * platform LC_CTYPE has to match LC_MONETARY/LC_NUMERIC to get sane
     * results.  Hence, we must temporarily set that category as well.
     */
 
    /* Save prevailing value of ctype locale */
    save_lc_ctype = setlocale(LC_CTYPE, NULL);
    if (!save_lc_ctype)
        elog(ERROR, "setlocale(NULL) failed");
    save_lc_ctype = pstrdup(save_lc_ctype);
 
    /* Here begins the critical section where we must not throw error */
 
    /* use numeric to set the ctype */
    setlocale(LC_CTYPE, locale_numeric);
#endif
 
    /* Get formatting information for numeric */
    setlocale(LC_NUMERIC, locale_numeric);
    extlconv = localeconv();
 
    /* Must copy data now in case setlocale() overwrites it */
    worklconv.decimal_point = strdup(extlconv->decimal_point);
    worklconv.thousands_sep = strdup(extlconv->thousands_sep);
    worklconv.grouping = strdup(extlconv->grouping);
 
#ifdef WIN32
    /* use monetary to set the ctype */
    setlocale(LC_CTYPE, locale_monetary);
#endif
 
    /* Get formatting information for monetary */
    setlocale(LC_MONETARY, locale_monetary);
    extlconv = localeconv();
 
    /* Must copy data now in case setlocale() overwrites it */
    worklconv.int_curr_symbol = strdup(extlconv->int_curr_symbol);
    worklconv.currency_symbol = strdup(extlconv->currency_symbol);
    worklconv.mon_decimal_point = strdup(extlconv->mon_decimal_point);
    worklconv.mon_thousands_sep = strdup(extlconv->mon_thousands_sep);
    worklconv.mon_grouping = strdup(extlconv->mon_grouping);
    worklconv.positive_sign = strdup(extlconv->positive_sign);
    worklconv.negative_sign = strdup(extlconv->negative_sign);
    /* Copy scalar fields as well */
    worklconv.int_frac_digits = extlconv->int_frac_digits;
    worklconv.frac_digits = extlconv->frac_digits;
    worklconv.p_cs_precedes = extlconv->p_cs_precedes;
    worklconv.p_sep_by_space = extlconv->p_sep_by_space;
    worklconv.n_cs_precedes = extlconv->n_cs_precedes;
    worklconv.n_sep_by_space = extlconv->n_sep_by_space;
    worklconv.p_sign_posn = extlconv->p_sign_posn;
    worklconv.n_sign_posn = extlconv->n_sign_posn;
 
    /*
     * Restore the prevailing locale settings; failure to do so is fatal.
     * Possibly we could limp along with nondefault LC_MONETARY or LC_NUMERIC,
     * but proceeding with the wrong value of LC_CTYPE would certainly be bad
     * news; and considering that the prevailing LC_MONETARY and LC_NUMERIC
     * are almost certainly "C", there's really no reason that restoring those
     * should fail.
     */
#ifdef WIN32
    if (!setlocale(LC_CTYPE, save_lc_ctype))
        elog(FATAL, "failed to restore LC_CTYPE to \"%s\"", save_lc_ctype);
#endif
    if (!setlocale(LC_MONETARY, save_lc_monetary))
        elog(FATAL, "failed to restore LC_MONETARY to \"%s\"", save_lc_monetary);
    if (!setlocale(LC_NUMERIC, save_lc_numeric))
        elog(FATAL, "failed to restore LC_NUMERIC to \"%s\"", save_lc_numeric);
 
    /*
     * At this point we've done our best to clean up, and can call functions
     * that might possibly throw errors with a clean conscience.  But let's
     * make sure we don't leak any already-strdup'd fields in worklconv.
     */
    PG_TRY();
    {
        int         encoding;
 
        /* Release the pstrdup'd locale names */
        pfree(save_lc_monetary);
        pfree(save_lc_numeric);
#ifdef WIN32
        pfree(save_lc_ctype);
#endif
 
        /* If any of the preceding strdup calls failed, complain now. */
        if (!struct_lconv_is_valid(&worklconv))
            ereport(ERROR,
                    (errcode(ERRCODE_OUT_OF_MEMORY),
                     errmsg("out of memory")));
 
        /*
         * Now we must perform encoding conversion from whatever's associated
         * with the locales into the database encoding.  If we can't identify
         * the encoding implied by LC_NUMERIC or LC_MONETARY (ie we get -1),
         * use PG_SQL_ASCII, which will result in just validating that the
         * strings are OK in the database encoding.
         */
        encoding = pg_get_encoding_from_locale(locale_numeric, true);
        if (encoding < 0)
            encoding = PG_SQL_ASCII;
 
        db_encoding_convert(encoding, &worklconv.decimal_point);
        db_encoding_convert(encoding, &worklconv.thousands_sep);
        /* grouping is not text and does not require conversion */
 
        encoding = pg_get_encoding_from_locale(locale_monetary, true);
        if (encoding < 0)
            encoding = PG_SQL_ASCII;
 
        db_encoding_convert(encoding, &worklconv.int_curr_symbol);
        db_encoding_convert(encoding, &worklconv.currency_symbol);
        db_encoding_convert(encoding, &worklconv.mon_decimal_point);
        db_encoding_convert(encoding, &worklconv.mon_thousands_sep);
        /* mon_grouping is not text and does not require conversion */
        db_encoding_convert(encoding, &worklconv.positive_sign);
        db_encoding_convert(encoding, &worklconv.negative_sign);
    }
    PG_CATCH();
    {
        free_struct_lconv(&worklconv);
        PG_RE_THROW();
    }
    PG_END_TRY();
 
    /*
     * Everything is good, so save the results.
     */
    CurrentLocaleConv = worklconv;
    CurrentLocaleConvAllocated = true;
    CurrentLocaleConvValid = true;
    return &CurrentLocaleConv;
}

References CurrentLocaleConvValid, db_encoding_convert(), elog(), encoding, ereport, errcode(), errmsg(), ERROR, FATAL, free_struct_lconv(), locale_monetary, locale_numeric, pfree(), PG_CATCH, PG_END_TRY, pg_get_encoding_from_locale(), PG_RE_THROW, PG_SQL_ASCII, PG_TRY, pstrdup(), setlocale, and struct_lconv_is_valid().

Referenced by cash_in(), cash_numeric(), cash_out(), int4_cash(), int8_cash(), NUM_prepare_locale(), and numeric_cash().

struct_lconv_is_valid()

static bool struct_lconv_is_valid ( struct lconv *  s )

static

Definition at line 418 of file pg_locale.c.

{
    if (s->decimal_point == NULL)
        return false;
    if (s->thousands_sep == NULL)
        return false;
    if (s->grouping == NULL)
        return false;
    if (s->int_curr_symbol == NULL)
        return false;
    if (s->currency_symbol == NULL)
        return false;
    if (s->mon_decimal_point == NULL)
        return false;
    if (s->mon_thousands_sep == NULL)
        return false;
    if (s->mon_grouping == NULL)
        return false;
    if (s->positive_sign == NULL)
        return false;
    if (s->negative_sign == NULL)
        return false;
    return true;
}

Referenced by PGLC_localeconv().

wchar2char()

size_t wchar2char	(	char *	to,
		const wchar_t *	from,
		size_t	tolen,
		pg_locale_t	locale
	)

Definition at line 2806 of file pg_locale.c.

{
    size_t      result;
 
    Assert(!locale || locale->provider == COLLPROVIDER_LIBC);
 
    if (tolen == 0)
        return 0;
 
#ifdef WIN32
 
    /*
     * On Windows, the "Unicode" locales assume UTF16 not UTF8 encoding, and
     * for some reason mbstowcs and wcstombs won't do this for us, so we use
     * MultiByteToWideChar().
     */
    if (GetDatabaseEncoding() == PG_UTF8)
    {
        result = WideCharToMultiByte(CP_UTF8, 0, from, -1, to, tolen,
                                     NULL, NULL);
        /* A zero return is failure */
        if (result <= 0)
            result = -1;
        else
        {
            Assert(result <= tolen);
            /* Microsoft counts the zero terminator in the result */
            result--;
        }
    }
    else
#endif                          /* WIN32 */
    if (locale == (pg_locale_t) 0)
    {
        /* Use wcstombs directly for the default locale */
        result = wcstombs(to, from, tolen);
    }
    else
    {
#ifdef HAVE_LOCALE_T
#ifdef HAVE_WCSTOMBS_L
        /* Use wcstombs_l for nondefault locales */
        result = wcstombs_l(to, from, tolen, locale->info.lt);
#else                           /* !HAVE_WCSTOMBS_L */
        /* We have to temporarily set the locale as current ... ugh */
        locale_t    save_locale = uselocale(locale->info.lt);
 
        result = wcstombs(to, from, tolen);
 
        uselocale(save_locale);
#endif                          /* HAVE_WCSTOMBS_L */
#else                           /* !HAVE_LOCALE_T */
        /* Can't have locale != 0 without HAVE_LOCALE_T */
        elog(ERROR, "wcstombs_l is not available");
        result = 0;             /* keep compiler quiet */
#endif                          /* HAVE_LOCALE_T */
    }
 
    return result;
}

References Assert(), elog(), ERROR, GetDatabaseEncoding(), locale, locale_t, PG_UTF8, and wcstombs_l.

Referenced by lowerstr_with_len(), str_initcap(), str_tolower(), and str_toupper().

Variable Documentation

collation_cache

HTAB* collation_cache = NULL

static

Definition at line 128 of file pg_locale.c.

Referenced by lookup_collation_cache().

CurrentLCTimeValid

bool CurrentLCTimeValid = false

static

Definition at line 115 of file pg_locale.c.

Referenced by assign_locale_time(), and cache_locale_time().

CurrentLocaleConvValid

bool CurrentLocaleConvValid = false

static

Definition at line 114 of file pg_locale.c.

Referenced by assign_locale_monetary(), assign_locale_numeric(), and PGLC_localeconv().

database_ctype_is_c

bool database_ctype_is_c = false

Definition at line 111 of file pg_locale.c.

Referenced by CheckMyDatabase(), lowerstr_with_len(), t_isalnum(), t_isalpha(), t_isdigit(), t_isprint(), t_isspace(), and TParserInit().

default_locale

struct pg_locale_struct default_locale

Definition at line 1375 of file pg_locale.c.

Referenced by check_icu_locale(), CheckMyDatabase(), lc_collate_is_c(), and pg_newlocale_from_collation().

locale_messages

char* locale_messages

Definition at line 93 of file pg_locale.c.

locale_monetary

char* locale_monetary

Definition at line 94 of file pg_locale.c.

Referenced by PGLC_localeconv().

locale_numeric

char* locale_numeric

Definition at line 95 of file pg_locale.c.

Referenced by PGLC_localeconv().

locale_time

char* locale_time

Definition at line 96 of file pg_locale.c.

Referenced by cache_locale_time().

localized_abbrev_days

char* localized_abbrev_days[7+1]

Definition at line 105 of file pg_locale.c.

Referenced by cache_locale_time(), DCH_from_char(), and DCH_to_char().

localized_abbrev_months

char* localized_abbrev_months[12+1]

Definition at line 107 of file pg_locale.c.

Referenced by cache_locale_time(), DCH_from_char(), and DCH_to_char().

localized_full_days

char* localized_full_days[7+1]

Definition at line 106 of file pg_locale.c.

Referenced by cache_locale_time(), DCH_from_char(), and DCH_to_char().

localized_full_months

char* localized_full_months[12+1]

Definition at line 108 of file pg_locale.c.

Referenced by cache_locale_time(), DCH_from_char(), and DCH_to_char().