Re: Server's Locale

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "T(dot)J(dot) Adami" <adamitj(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Server's Locale
Date: 2007-10-31 20:03:28
Message-ID: 19055.1193861008@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2007-10-31 20:12:51 Re: AutoVacuum Behaviour Question
Previous Message Ian Goldsmid 2007-10-31 19:56:39 can someone please tell me how to unsubscribe from this group - thanks