Re: Finding last checkpoint time - Mailing list pgsql-general

From Tom Lane
Subject Re: Finding last checkpoint time
Date
Msg-id 2954.1281461575@sss.pgh.pa.us
Whole thread Raw
In response to Re: Finding last checkpoint time  (Bruce Momjian <bruce@momjian.us>)
Responses Re: Finding last checkpoint time
List pgsql-general
Bruce Momjian <bruce@momjian.us> writes:
> Greg Sabino Mullane wrote:
>> Specifically, LANGUAGE changes the headers of pg_controldata
>> (but not the actual output, LC_ALL does that). Thanks for the
>> nudge, I'll get to rewriting some code.

> pg_upgrade does this in controldata.c for this exact reason:

>         /*
>          * Because we test the pg_resetxlog output strings, it has to be in
>          * English.
>          */
>         if (getenv("LANG"))
>             lang = pg_strdup(ctx, getenv("LANG"));
>     #ifndef WIN32
>         putenv(pg_strdup(ctx, "LANG=C"));
>     #else
>         SetEnvironmentVariableA("LANG", "C");
>     #endif

You do realize that's far from bulletproof?  To be sure that that does
anything, you'd need to set (or unset) LC_ALL and LC_MESSAGES as well.
And I thought Windows spelled it LANGUAGE not LANG ...

            regards, tom lane

pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: RETURN QUERY SELECT & TYPE
Next
From: Jacqui Caren-home
Date:
Subject: Re: MySQL versus Postgres