Re: Overriding local encoding defaults - Mailing list pgsql-novice

From Lukasz Brodziak
Subject Re: Overriding local encoding defaults
Date
Msg-id AANLkTimApfuPXFjcinu9n4oPt=Xri4LASvA37R6vXnC1@mail.gmail.com
Whole thread Raw
In response to Re: Overriding local encoding defaults  (Bob McConnell <rmcconne@lightlink.com>)
List pgsql-novice
I have a similar problem. When I try to put up a cluster with encoding
set to CP1250 I get an info that this is not a proper server encoding
type. The initdb and pg_createcluster force me to use utf8 with pl_PL
locale. Is there a way to override this as I know that CP1250 is
supported by PG. The system is Ubuntu 10.04.

2010/10/18 Bob McConnell <rmcconne@lightlink.com>:
> Tom Lane wrote:
>>
>> Bob McConnell <rmcconne@lightlink.com> writes:
>>>
>>> I still don't understand why a server process should care about the local
>>> console. Are there any plans to fix that?
>>
>> No, because it's not broken.  Where else should initdb get the default
>> locale setting, if not from the environment it's invoked in?
>
> Something that critical should never be left to a default. It should be
> explicitly required in the command line and ignore all of the local
> settings. In this case, the local settings are irrelevant anyway. The
> console will never be used to access the DB on a headless server.
>
> But what I think is broken is that the command line argument is blocked by
> the local settings. When the command line says to use UTF-8, it should
> override any and all local settings. They become superfluous.
>
> Bob McConnell
> N2SPP
>
>
> --
> Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice
>



--
Łukasz Brodziak
II MU Bioinformatyka

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Dumping grants
Next
From: Manuel Rivero
Date:
Subject: Doubt with role creation