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 1u3pu1-003kPG-6S for pgsql-hackers@arkaria.postgresql.org; Sun, 13 Apr 2025 05:29:09 +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 1u3pty-003t43-GX for pgsql-hackers@arkaria.postgresql.org; Sun, 13 Apr 2025 05:29:07 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u3pty-003t3v-5h for pgsql-hackers@lists.postgresql.org; Sun, 13 Apr 2025 05:29:07 +0000 Received: from sss.pgh.pa.us ([68.162.161.243]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1u3ptw-0004I4-1n for pgsql-hackers@postgresql.org; Sun, 13 Apr 2025 05:29:06 +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 53D5T0ci769599; Sun, 13 Apr 2025 01:29:00 -0400 From: Tom Lane To: Abhishek Chanda cc: PostgreSQL Hackers Subject: Re: Adding error messages to a few slash commands In-reply-to: References: Comments: In-reply-to Abhishek Chanda message dated "Sat, 12 Apr 2025 22:43:15 -0500" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <769597.1744522140.1@sss.pgh.pa.us> Date: Sun, 13 Apr 2025 01:29:00 -0400 Message-ID: <769598.1744522140@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Abhishek Chanda writes: > Currently, some slash commands in psql return an error saying "Did not > find any XXXX named YYYY" while some return an empty table. This patch > changes a few of the slash commands to return a similar error message. Personally, if I were trying to make these things consistent, I'd have gone in the other direction (ie return empty tables). We don't make psql throw an error when an ordinary user query returns zero rows; why should \d commands do that? > Also, I know that we are in a > feature freeze, is such a change acceptable now? Whether changing this is a good idea or not, it's surely hard to claim that it's a bug fix. So I'd say it's out of scope for post-feature-freeze. regards, tom lane