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.96) (envelope-from ) id 1wzEao-003tNp-04 for pgsql-hackers@arkaria.postgresql.org; Wed, 26 Aug 2026 14:27:06 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wzEal-00DkY6-2j for pgsql-hackers@arkaria.postgresql.org; Wed, 26 Aug 2026 14:27:03 +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.96) (envelope-from ) id 1wzEal-00DkXx-1k for pgsql-hackers@lists.postgresql.org; Wed, 26 Aug 2026 14:27:03 +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.98.2) (envelope-from ) id 1wzEaj-00000002WYd-41MK for pgsql-hackers@postgresql.org; Wed, 26 Aug 2026 14:27:02 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.18.1/8.18.1) with ESMTP id 67QEQw22697478; Wed, 26 Aug 2026 10:26:58 -0400 From: Tom Lane To: Alexander Lakhin cc: Michael Paquier , pgsql-hackers , Justin Pryzby Subject: Re: Internal error codes triggered by regression tests and user queries, take 2 In-reply-to: <94ac928b-8370-4db5-ada5-579a9ebc089d@gmail.com> References: <94ac928b-8370-4db5-ada5-579a9ebc089d@gmail.com> Comments: In-reply-to Alexander Lakhin message dated "Wed, 26 Aug 2026 17:00:00 +0300" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <697476.1787754418.1@sss.pgh.pa.us> Date: Wed, 26 Aug 2026 10:26:58 -0400 Message-ID: <697477.1787754418@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Alexander Lakhin writes: > Please take a look at the follow-up to [0]. I've prepared a patch to > assign error codes for errors reached by the following queries: I'm not on board with these proposed changes to [try_]relation_open. They're basically band-aids rather than fixes of the root problems. That is, if someone passes OID 0 to relation_open, that IS an internal bug; labeling it otherwise is a lie and does nothing to fix the real problem at the caller level. A lot of these other proposed changes have the same whiff of blaming the messenger rather than looking for the root cause. regards, tom lane