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 1r6DhA-00048m-Aq for pgsql-general@arkaria.postgresql.org; Thu, 23 Nov 2023 17:40:56 +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 1r6Dh8-002pSN-JO for pgsql-general@arkaria.postgresql.org; Thu, 23 Nov 2023 17:40: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 1r6Dh8-002pSE-8M for pgsql-general@lists.postgresql.org; Thu, 23 Nov 2023 17:40:54 +0000 Received: from sss.pgh.pa.us ([68.162.161.243]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r6Dh5-0070is-LP for pgsql-general@lists.postgresql.org; Thu, 23 Nov 2023 17:40:52 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 3ANHeoDM3156491; Thu, 23 Nov 2023 12:40:50 -0500 From: Tom Lane To: Zahir Lalani cc: "pgsql-general@lists.postgresql.org" Subject: Re: Odd Shortcut behaviour in PG14 In-reply-to: References: Comments: In-reply-to Zahir Lalani message dated "Thu, 23 Nov 2023 16:55:56 +0000" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <3156489.1700761250.1@sss.pgh.pa.us> Date: Thu, 23 Nov 2023 12:40:50 -0500 Message-ID: <3156490.1700761250@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Zahir Lalani writes: > Got a really weird problem with shortcut processing on one server. This question is unanswerable as given. You have not even defined what you mean by "fail" (error? wrong query result?), let alone provided enough detail for someone else to reproduce the problem. regards, tom lane