BUG #6288: Is ALTER ROLE set client_encoding broken in 9.1?

From: "Maksym Boguk" <maxim(dot)boguk(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #6288: Is ALTER ROLE set client_encoding broken in 9.1?
Date: 2011-11-10 11:09:31
Message-ID: 201111101109.pAAB9Vja074963@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 6288
Logged by: Maksym Boguk
Email address: maxim(dot)boguk(at)gmail(dot)com
PostgreSQL version: 9.1
Operating system: Linux Ubuntu
Description: Is ALTER ROLE set client_encoding broken in 9.1?
Details:

I found common way deal with legacy applications encoding issues through
ALTER ROLE ... set client_encoding '...';

Doesn't work at 9.1 database:

test:

postgres(at)db13:/home/mboguk$ psql
psql (9.1.1)
Type "help" for help.

postgres=# CREATE DATABASE test WITH TEMPLATE = template0 ENCODING='KOI8R'
LC_COLLATE = 'ru_RU.KOI8-R' LC_CTYPE = 'ru_RU.KOI8-R';
CREATE DATABASE
postgres=# create role test with login;
CREATE ROLE
postgres=# alter role test set client_encoding to 'KOI8R';
ALTER ROLE
postgres=# \q

postgres(at)db13:/home/mboguk$ psql -U test
psql (9.1.1)
Type "help" for help.

test=> show client_encoding ;
client_encoding
-----------------
UTF8
(1 row)

The same way work without any issues with 8.3 and 8.4.

PS: it's possible i'm missing something obvious.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message MOHSEN MOMENI 2011-11-10 13:39:49 HElp
Previous Message Heikki Linnakangas 2011-11-10 10:20:35 Re: Add statistics_collector_listen_addresses to fix hard-coding of "localhost"