Client encoding not the same as the db encoding

From: Clodoaldo Neto <clodoaldo(dot)pinto(dot)neto(at)gmail(dot)com>
To: PostgreSQL - General ML <pgsql-general(at)postgresql(dot)org>
Subject: Client encoding not the same as the db encoding
Date: 2012-02-29 14:47:21
Message-ID: CA+Z73LG5uU=skTJGCA31D01XZSzpn1nzPkP=4wTVk5TOO2eG6A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

In 9.1.3 the client encoding is not defaulting to the db encoding:

postgresql.conf:

#client_encoding = sql_ascii

=> show server_encoding;
server_encoding
-----------------
SQL_ASCII

=> show client_encoding;
client_encoding
-----------------
UTF8

In 9.0 the client encoding defaults to the db encoding:

postgresql.conf:

#client_encoding = sql_ascii

=> show client_encoding;
client_encoding
-----------------
SQL_ASCII

=> show server_encoding;
server_encoding
-----------------
SQL_ASCII

What am i missing? Regards, Clodoaldo

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adam Bruss 2012-02-29 14:54:44 Re: accumulating handles problem on machine running postgresql
Previous Message chinnaobi 2012-02-29 12:40:17 Re: archive_cleanup_command recovery.conf Standby server error