Re: BUG #3792: cluster in UTF deny database in LATIN2

[Heikki Linnakangas <heikki(at)enterprisedb(dot)com>]

Marek wrote:
> Bug reference:      3792
> Logged by:          Marek
> Email address:      wrobel(dot)marek(at)gmail(dot)com
> PostgreSQL version: 8.3beta3
> Operating system:   Linux  2.6.23.1-49.fc8 #1 SMP x86_64
> Description:        cluster in UTF deny database in LATIN2
> Details: 
>
> This postgresql was compiled myself.
> I have cluster inited in UTF-8. 
>
> createdb -U postgres -E 'latin2' foo
>
> createdb: database creation failed: ERROR:  encoding LATIN2 does not match
> server's locale pl_PL.UTF-8
> The server's LC_CTYPE setting requires encoding UTF8.
>
> When I install postresql 8.2 from rpm an init cluster as UTF, I don't have
> any problem to create database in LATIN2.

That's intentional. You're trying to use a UTF-8 locale, with LATIN2 
encoding. That's not going to work properly. We used to be lax about 
that, but in 8.3 we check that the encoding matches the encoding the 
locale expects, and throw an error if they don't.

Hmm, apparently that's not mentioned in the release notes. It probably 
should be.

--
  Heikki Linnakangas
  EnterpriseDB   http://www.enterprisedb.com