Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qaDt1-008ZRb-Vu for pgsql-committers@arkaria.postgresql.org; Sun, 27 Aug 2023 11:24:55 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qaDt0-00Gb9L-Iw for pgsql-committers@arkaria.postgresql.org; Sun, 27 Aug 2023 11:24:54 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qaDt0-00Gb96-BA for pgsql-committers@lists.postgresql.org; Sun, 27 Aug 2023 11:24:54 +0000 Received: from relay8-d.mail.gandi.net ([217.70.183.201]) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qaDsw-001DsX-RV for pgsql-committers@lists.postgresql.org; Sun, 27 Aug 2023 11:24:52 +0000 Received: by mail.gandi.net (Postfix) with ESMTPSA id D8E391BF209; Sun, 27 Aug 2023 11:24:45 +0000 (UTC) Content-Type: multipart/alternative; boundary="------------UquBCmM2B0qCXF0L6DlYpVy3" Message-ID: Date: Sun, 27 Aug 2023 07:24:44 -0400 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.5.0 Subject: Re: pgsql: Cache by-reference missing values in a long lived context Content-Language: en-US To: Tom Lane , Alvaro Herrera Cc: pgsql-committers@lists.postgresql.org References: <20230826162541.4cny4fb6z2cvpy4j@alvherre.pgsql> <209722.1693086087@sss.pgh.pa.us> From: Andrew Dunstan In-Reply-To: <209722.1693086087@sss.pgh.pa.us> X-GND-Sasl: adsend@dunslane.net List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------UquBCmM2B0qCXF0L6DlYpVy3 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit On 2023-08-26 Sa 17:41, Tom Lane wrote: > Alvaro Herrera writes: >> On 2023-Aug-25, Tom Lane wrote: >>> ... Were we relying on "{ 0 }" >>> anywhere else pre-v12? >> We have a few occurrences of {0} in initializations in pg11, so it >> should work. > Ah, indeed. Objection withdrawn then. > > OK, thanks, done. cheers andrew -- Andrew Dunstan EDB:https://www.enterprisedb.com --------------UquBCmM2B0qCXF0L6DlYpVy3 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit


On 2023-08-26 Sa 17:41, Tom Lane wrote:
Alvaro Herrera <alvherre@alvh.no-ip.org> writes:
On 2023-Aug-25, Tom Lane wrote:
... Were we relying on "{ 0 }"
anywhere else pre-v12?

      
We have a few occurrences of {0} in initializations in pg11, so it
should work.
Ah, indeed.  Objection withdrawn then.

			


OK, thanks, done.


cheers


andrew

--
Andrew Dunstan
EDB: https://www.enterprisedb.com
--------------UquBCmM2B0qCXF0L6DlYpVy3--