Re: BUG #6308: Problem w. encoding in client - Mailing list pgsql-bugs

From Thomas Goerner
Subject Re: BUG #6308: Problem w. encoding in client
Date
Msg-id 021C7C8A088F4CFBA95CCF9A157E1986@tglaptp
Whole thread Raw
In response to Re: BUG #6308: Problem w. encoding in client  (Craig Ringer <ringerc@ringerc.id.au>)
List pgsql-bugs
Hello Craig,

=20

it seems as if there were illegal chars in the originally dumped database,
so the dump/restore problem might be due to this. At the moment we are doing
further investigation on this issue.=20

=20

But the problem regarding message output from the client applications still
persists. We are now setting up another set of 32/64-bit (virtual) Windows 7
machines to verify that the problem occurs only on 64 bit windows.

=20

I will keep you informed.

=20

=20

Regards

Thomas

=20

=20

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
click:ware Informationstechnik GmbH
Thomas Goerner
Gesch=E4ftsf=FChrer
fon: 0221 - 13 99 88-0
fax: 0221 - 13 99 88-79
Kamekestra=DFe 19
50672 K=F6ln
 <mailto:tg@clickware.de> tg@clickware.de
 <http://www.clickware.de/> www.clickware.de
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
Kennen Sie schon unser GasDataWarehouse -=20
Die kosteng=FCnstige L=F6sung f=FCr den Austausch=20
von Gasmessdaten?
 <http://www.gasdatawarehouse.de/> www.gasdatawarehouse.de

  _____=20=20

Von: Craig Ringer [mailto:ringerc@ringerc.id.au]=20
Gesendet: Dienstag, 29. November 2011 03:33
An: Thomas Goerner
Cc: pgsql-bugs@postgresql.org
Betreff: Re: [BUGS] BUG #6308: Problem w. encoding in client

=20

On 11/28/2011 08:26 PM, Thomas Goerner wrote:=20

Hello Craig,

=20

thanks for your answer.

=20

=20

> Restore using PgAdmin III or using a unicode console.=20

> This is a limitation of using a Win1252 client encoding when restoring=20

> data that isn't restricted to Win1252 and cannot be fixed directly.

=20

That's new to me. AFAIK pg_restore looks into the dump file and sets the
client encoding accordingly (In fact the dump contains the statement SET
client_encoding =3D 'UTF8';). Is this overridden by PGCLIENTENCODING? And if
so, should it be?


Nope, pg_restore should be using UTF8 as the client encoding in that case.
If there are any errors or notices it won't be able to emit them correctly
on the terminal though, as win1252 can't represent everything in UTF8 (and
IIRC pg_restore doesn't recode from client_encoding to terminal encoding
anyway).

If the restore its self is failing then I agree that something's not working
properly, because you should be able to use a client_encoding different to
your terminal encoding. I wonder if recent changes intended to get psql to
pick up the terminal encoding automatically have had the unintended
side-effect of overriding pg_restore's attempt to set the client_encoding?

I'm rather surprised you only see this on x64. You're using the same Windows
and Pg version for both x64 and x64 but only the x64 test fails?

--
Craig Ringer

pgsql-bugs by date:

Previous
From: laurenz.albe@wien.gv.at
Date:
Subject: BUG #6318: pg_dump for non-template languages is broken
Next
From: hmf@alkheme.com
Date:
Subject: BUG #6317: sequence error for pg_dump