Re: BUG: Incorrect working with POSIX locale if database in UTF-8encoding - Mailing list pgsql-general

From Jehan-Guillaume (ioguix) de Rorthais
Subject Re: BUG: Incorrect working with POSIX locale if database in UTF-8encoding
Date
Msg-id 20181018154504.2e87ee54@firost
Whole thread Raw
In response to BUG: Incorrect working with POSIX locale if database in UTF-8encoding  (Олег Самойлов <splarv@ya.ru>)
List pgsql-general
On Wed, 17 Oct 2018 12:29:52 +0300
Олег Самойлов <splarv@ya.ru> wrote:

> There is not problem with systemctl, if system locale setted by localectl is
> the same as database locale. But, as I said, there is problem with pacemaker
> pgsqlms module. And I think this is incorrect behavior. Database may write in
> log messages in database locale, if this messages arises inside connection to
> this database. But common messages, such as messages on start cluster or
> errors on start cluster must written according to locale settings, and if
> locale empty (POSIX) such messages must be in english. And if messages not in
> english they must be visible as is, not as ‘???’. :) It works inside
> connection, why this does not work on start/stop?

It seems like POSIX support ASCII and some additional characters. So maybe the
character encoding used in the database is just incompatible with POSIX, ie.
POSIX does not support wide chars. As you can see, characters from ASCII table
are printed correctly.


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: convert real to numeric.
Next
From: Dinko Papak
Date:
Subject: Help with list partitioning on expression