Re: Server's Locale

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

"T.J. Adami" <adamitj(at)gmail(dot)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