Re: BUG #7493: Postmaster messages unreadable in a Windows console

From: Alexander Law <exclusion(at)gmail(dot)com>
To: Noah Misch <noah(at)leadboat(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, Magnus Hagander <magnus(at)hagander(dot)net>, Andrew Dunstan <andrew(at)dunslane(dot)net>
Subject: Re: BUG #7493: Postmaster messages unreadable in a Windows console
Date: 2013-06-24 12:00:00
Message-ID: 51C834C0.7010200@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-general pgsql-hackers

Hello Noah,

Thanks for your work, your patch is definitely better. I agree that this
approach much more generic.
23.06.2013 20:53, Noah Misch wrote:
> The attached revision fixes all above points. Would you look it over? The
> area was painfully light on comments, so I added some. I renamed
> pgwin32_toUTF16(), which ceases to be a good name now that it converts from
> message encoding, not database encoding. GetPlatformEncoding() became unused,
> so I removed it. (If we have cause reintroduce the exact same concept later,
> GetTTYEncoding() would name it more accurately.)
Yes, the patch works for me. I have just a little question about
pgwin32_message_to_UTF16. Do we need to convert SQL_ASCII through UTF8
or should SQL_ASCII be mapped to 20127 (US-ASCII (7-bit))?
> What should we do for the back branches, if anything? Fixes for garbled
> display on consoles and event logs are fair to back-patch, but users might be
> accustomed to the present situation for SQL_ASCII databases. Given the low
> incidence of complaints and the workaround of using logging_collector, I am
> inclined to put the whole thing in master only.
I thought that the change could be a first step to the PosgreSQL log
encoding normalization. Today the log may contain messages with
different encodings (we had a long discussion a year ago:
http://www.postgresql.org/message-id/5007C399.6000405@gmail.com)
Now the new function GetMessageEncoding allows to convert all the
messages consistently. If the future log encoding fix will be considered
as important enough to be backported, then this patch should be
backported too.

Thanks again!

Best regards,
Alexander

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Amit Kapila 2013-06-24 12:43:35 Re: BUG #8242: No way to debug "subquery must return only one column" error
Previous Message Борис Ромашов 2013-06-24 07:53:25 Re: BUG #8242: No way to debug "subquery must return only one column" error

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2013-06-24 12:32:32 Re: missing FROM-clause in version 9.2
Previous Message Stuart Ford 2013-06-24 11:13:08 pg_largeobject.sql script not run after upgrade

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2013-06-24 12:12:34 Re: preserving forensic information when we freeze
Previous Message Dimitri Fontaine 2013-06-24 11:20:44 Re: in-catalog Extension Scripts and Control parameters (templates?)