Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jWkxE-0001ap-Py for pgsql-hackers@arkaria.postgresql.org; Thu, 07 May 2020 18:09:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jWkxD-0002l5-PS for pgsql-hackers@arkaria.postgresql.org; Thu, 07 May 2020 18:09:03 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jWkxD-0002kx-81 for pgsql-hackers@lists.postgresql.org; Thu, 07 May 2020 18:09:03 +0000 Received: from anastigmatix.net ([68.171.219.55]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jWkxB-0000jj-5A for pgsql-hackers@postgresql.org; Thu, 07 May 2020 18:09:02 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=anastigmatix.net; s=default; h=Content-Transfer-Encoding:Content-Type: In-Reply-To:MIME-Version:Date:Message-ID:From:Cc:References:To:Subject:Sender :Reply-To:Content-ID:Content-Description:Resent-Date:Resent-From: Resent-Sender:Resent-To:Resent-Cc:Resent-Message-ID:List-Id:List-Help: List-Unsubscribe:List-Subscribe:List-Post:List-Owner:List-Archive; bh=LorCb6NwslO9TfAnxzgxEp7Dbu9J29c3C/ASIqKHAH4=; b=I17pgroU3gd92sENaP6P7vSyov z0W2hFBinwlRyIJQOd4MOaBM6Bt58s1ZCbCU2K+a4FZbC9X6OY/t7/KTbC5jN1HuI4AU+k1QyTjYv sWAes4EKmqcujJcbA5Oi6oxVlv3/dq8x6HZkPxAvxZrxpoyg2hYJW18xJpd8bOSIaP0nj+UvPqOxV k0asWKYKxUK+K3UKMx6YjQJJBtscCsU/I7ZmWiehBmOxwNjCwg4uk8L+dzZ3uj7QWfmnnU1S5RX4N jN4JONV7maBt64ATARe51GszibHAwnU+PG1kqutDLMQcWViUisfp5b25uXMMRINiEb1PXymsSQ1sK 0/yBaIjA==; Received: from [184.19.31.139] (port=43086) by bay.acenet.us with esmtpsa (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.93) (envelope-from ) id 1jWkx9-008GNL-Fo; Thu, 07 May 2020 14:08:59 -0400 Subject: Re: PG 13 release notes, first draft To: Bruce Momjian References: <20200505031600.GB21752@momjian.us> <20200505143118.GH21752@momjian.us> <5EB317A8.1020907@anastigmatix.net> <20200507134657.GK3649@momjian.us> Cc: John Naylor , PostgreSQL-development From: Chapman Flack X-Enigmail-Draft-Status: N1110 Message-ID: <5EB44EBA.3040206@anastigmatix.net> Date: Thu, 7 May 2020 14:08:58 -0400 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:38.0) Gecko/20100101 Thunderbird/38.7.0 MIME-Version: 1.0 In-Reply-To: <20200507134657.GK3649@momjian.us> Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: 7bit X-OutGoing-Spam-Status: No, score=-95.0 X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - bay.acenet.us X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - anastigmatix.net X-Get-Message-Sender-Via: bay.acenet.us: authenticated_id: chap@anastigmatix.net X-Authenticated-Sender: bay.acenet.us: chap@anastigmatix.net X-Source: X-Source-Args: X-Source-Dir: X-From-Rewrite: unmodified, already matched List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 05/07/20 09:46, Bruce Momjian wrote: > Ah, very good point. New text is: > > Allow Unicode escapes, e.g., E'\u####', in databases that do not > use UTF-8 encoding (Tom Lane) > > The Unicode characters must be available in the database encoding. > ... > > I am only using E'\u####' as an example. Hmm, how about: Allow Unicode escapes, e.g., E'\u####' or U&'\####', to represent any character available in the database encoding, even when that encoding is not UTF-8. which I suggest as I recall more clearly that the former condition was not that such escapes were always rejected in other encodings; it was that they were rejected if they represented characters outside of ASCII. (Yossarian let out a respectful whistle.) My inclination is to give at least one example each of the E and U& form, if only so the casual reader of the notes may think "say! I hadn't heard of that other form!" and be inspired to find out about it. But perhaps it seems too much. Regards, -Chap