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 1naeOO-0003qS-FI for pgsql-committers@arkaria.postgresql.org; Sat, 02 Apr 2022 14:06:16 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1naeON-0004tq-9C for pgsql-committers@arkaria.postgresql.org; Sat, 02 Apr 2022 14:06:15 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1naeON-0004tg-2I for pgsql-committers@lists.postgresql.org; Sat, 02 Apr 2022 14:06:15 +0000 Received: from relay2-d.mail.gandi.net ([217.70.183.194]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1naeOK-0004Br-Ht for pgsql-committers@lists.postgresql.org; Sat, 02 Apr 2022 14:06:14 +0000 Received: (Authenticated sender: adsend@dunslane.net) by mail.gandi.net (Postfix) with ESMTPSA id 6D84240003; Sat, 2 Apr 2022 14:06:09 +0000 (UTC) Message-ID: <6c142c77-41e3-48dc-bf4d-6e9b47ac2ca3@dunslane.net> Date: Sat, 2 Apr 2022 10:06:07 -0400 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:91.0) Gecko/20100101 Thunderbird/91.5.0 Subject: Re: pgsql: SQL/JSON query functions Content-Language: en-US To: Tom Lane , Michael Paquier Cc: pgsql-committers@lists.postgresql.org References: <1259106.1648876834@sss.pgh.pa.us> From: Andrew Dunstan In-Reply-To: <1259106.1648876834@sss.pgh.pa.us> Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 4/2/22 01:20, Tom Lane wrote: > Michael Paquier writes: >> On Tue, Mar 29, 2022 at 08:57:37PM +0000, Andrew Dunstan wrote: >>> SQL/JSON query functions >> Some of the tests introduced in this commit are a bit unstable when >> run through a primary/standby setup. > Yeah, looks like some of these queries need an ORDER BY. > > Done. cheers andrew -- Andrew Dunstan EDB: https://www.enterprisedb.com