Re: Server's Locale - Mailing list pgsql-general

From Tom Lane
Subject Re: Server's Locale
Date
Msg-id 19055.1193861008@sss.pgh.pa.us
Whole thread Raw
In response to Server's Locale  ("T.J. Adami" <adamitj@gmail.com>)
List pgsql-general
"T.J. Adami" <adamitj@gmail.com> writes:
> I'm testing PostgreSQL 8.3-beta 1, and still do not fix this message:
> "createdb: database creation failed: ERROR:  encoding LATIN1 does not
> match server's locale Portuguese_Brazil.1252
> DETAIL:  The server's LC_CTYPE setting requires encoding WIN1252."

That's intentional.

> On PostgreSQL 8.2.5 I'm able to create data dir with initdb and locale
> Latin1, and after create individual databases with SQL_ANSI or
> UNICODE.

You might've been able to do it, but it wouldn't have worked very well.
We're tired of reading bug reports from people who misconfigure their
databases that way, so we put in a check to prevent it.

            regards, tom lane

pgsql-general by date:

Previous
From: Douglas McNaught
Date:
Subject: Re: Securing stored procedures and triggers
Next
From: Bruce Momjian
Date:
Subject: Re: AutoVacuum Behaviour Question