Thank you very much for information. I lost some brain cells during fighting with that problem yesterday.
However personally I'm think this behavior is rather non-intuitive: postgres@db13:~$ psql -U slony -d test -c 'show client_encoding' client_encoding ----------------- UTF8 (1 row) postgres@db13:~$ psql -U slony -d test -c 'show client_encoding' | head -10 client_encoding ----------------- KOI8R (1 row) On Fri, Nov 11, 2011 at 1:55 AM, Tom Lane <t...@sss.pgh.pa.us> wrote: > "Maksym Boguk" <maxim.bo...@gmail.com> writes: >> Description: Is ALTER ROLE set client_encoding broken in 9.1? > > No, but I think psql prefers to set its encoding according to its locale > enviroment these days. > > regards, tom lane > -- Maxim Boguk Senior Postgresql DBA. Skype: maxim.boguk Jabber: maxim.bo...@gmail.com LinkedIn profile: http://nz.linkedin.com/in/maximboguk If they can send one man to the moon... why can't they send them all? МойКруг: http://mboguk.moikrug.ru/ Сила солому ломит, но не все в нашей жизни - солома, да и сила далеко не все. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs