Re: BUG #4196: Backend crash possible with psql - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #4196: Backend crash possible with psql
Date
Msg-id 22106.1211817509@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #4196: Backend crash possible with psql  (Daniel Migowski <dmigowski@ikoffice.de>)
Responses Re: BUG #4196: Backend crash possible with psql
List pgsql-bugs
Daniel Migowski <dmigowski@ikoffice.de> writes:
> client_encoding: WIN1252
> server_encoding: UTF8
> lc_collate:      German_Germany.1252
> lc_ctype:        German_Germany.1252
> lc_messages:     German_Germany

Thanks for the info --- we have been unable to get these values from
previous complainants, so this is a real help.

> Please let me know if you need more info. For me it looks like the
> server reads the localized error messages in system encoding (win1252),
> but assumes they are in utf8 in the server.

Yeah, that's what I think too.  Specifically, we expect the gettext
package to deliver translated error messages in the server_encoding,
but it seems that's not what we're getting on Windows.  Without having
dug into the gettext code, I wonder whether it is looking at lc_ctype
and thinking it should return WIN1252 strings.

Another interesting question is how initdb allowed you to select the
above combination of settings.  8.3 is supposed to enforce that
server_encoding is the same as the encoding implied by lc_ctype,
which is evidently not the case here.  I recall we were tinkering with
that code before 8.3 release, but I guess it's still not right :-(

            regards, tom lane

pgsql-bugs by date:

Previous
From: Daniel Migowski
Date:
Subject: Re: BUG #4196: Backend crash possible with psql
Next
From: Tom Lane
Date:
Subject: Re: BUG #4196: Backend crash possible with psql