[pgbr-geral] Como configurar o PostgreSQL 8.3 para pt_BR?

[Osvaldo Rosario Kussama]

Leandro DUTRA escreveu:
> 2008/3/5, Ribamar Sousa <ribafs em gmail.com>:
>>  Quando eu crio um cluster com encoding latin1 também posso criar banco
>>  com utf8, mas se tenho um cluster em utf8 não posso criar banco com
>>  latin1.
> 
> Interessante, isso está documentado?
> 

http://www.postgresql.org/docs/8.3/interactive/multibyte.html

"An important restriction, however, is that each database 
character set must be compatible with the server's LC_CTYPE 
setting. When LC_CTYPE is C or POSIX, any character set is 
allowed, but for other settings of LC_CTYPE there is only one 
character set that will work correctly. Since the LC_CTYPE 
setting is frozen by initdb, the apparent flexibility to use 
different encodings in different databases of a cluster is more 
theoretical than real, except when you select C or POSIX locale 
(thus disabling any real locale awareness). It is likely that 
these mechanisms will be revisited in future versions of PostgreSQL."

Osvaldo