Horton

Re: Encoding problems with "COMMENT ON DATABASE .." causing pg_restore (and pg_upgrade) to fail

Tatsuo Ishii <t-ishii@sra.co.jp>

View thread
From: Tatsuo Ishii <t-ishii@sra.co.jp>
To: bruce@momjian.us
Cc: jan.lentfer@web.de, pgsql-bugs@postgresql.org
Date: 2016-02-17T00:25:51Z
Lists: pgsql-bugs 
> I see no one else commented on this.  We have trouble keeping the global
> system catalogs consistent when databases in the same cluster use
> different encodings.  I am not sure how we could improve this.

Long time ago I proposed an idea to solve this kind of problems:

http://www.postgresql.org/message-id/20131112.155752.666523035722474275.t-ishii@sraoss.co.jp

The implementation details are not necessarily the best but still I
believe what we need is "round trip encoding conversion safe"
universal encoding for internal use.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp