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 1srdfx-003TdL-IU for pgsql-hackers@arkaria.postgresql.org; Fri, 20 Sep 2024 13:27:58 +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 1srdfv-006Dk8-8U for pgsql-hackers@arkaria.postgresql.org; Fri, 20 Sep 2024 13:27:56 +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 1srdfu-006Dk0-V4 for pgsql-hackers@lists.postgresql.org; Fri, 20 Sep 2024 13:27:56 +0000 Received: from momjian.us ([72.94.173.45]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1srdfo-000Bv3-6m for pgsql-hackers@postgresql.org; Fri, 20 Sep 2024 13:27:55 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=momjian.us; s=2024011501; h=In-Reply-To:Content-Transfer-Encoding:Content-Type: MIME-Version:References:Message-ID:Subject:Cc:To:From:Date:Sender:Reply-To: Content-ID:Content-Description; bh=whTJqvi8kucb/o/mhcoRe/Jb8UAByJoaTv9uIAde044=; b=f7gSpOfP/bPGtpo8+cT8gOmFn7 pu38SynzYoptFmwxU7nfHC5+PSSJqLhYGobdSnk9MZlkPrm8AlD20gRSHxjIIJ4hoBQRyiZTBp2pL Y7d7ZA5IIgUrWTXP3C5zX2Eu3ATxLeUdbaQgPmgR5mY+2h0I4rwTwjfBqFitFrN5o5YKzS1KePe5d AP+lQ+3iRJjLDq9bowZHETSgp81C2FElVuhj3osYDSadPFrqe5D/5V3brYi6Ot5CQ6g8xlZUEi9VO RoO27YDAmmKDkvUzt70u1PBn618GHxdfD9TozoozJUj76RQcGlbVcKyM6MQXpwpeLQd5OyvJwGSdK L8d7yV7Q==; Received: from bruce by momjian.us with local (Exim 4.96) (envelope-from ) id 1srdfn-00Fv46-0a; Fri, 20 Sep 2024 09:27:47 -0400 Date: Fri, 20 Sep 2024 09:27:47 -0400 From: Bruce Momjian To: jian he Cc: Tom Lane , PostgreSQL-development Subject: Re: attndims, typndims still not enforced, but make the value within a sane threshold Message-ID: References: <1807434.1726668657@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, Sep 20, 2024 at 10:11:00AM +0800, jian he wrote: > On Wed, Sep 18, 2024 at 10:35 PM jian he wrote: > > > > > The last time this was discussed, I think the conclusion was > > > we should remove attndims and typndims entirely on the grounds > > > that they're useless. I certainly don't see a point in adding > > > more logic that could give the misleading impression that they > > > mean something. > > > > > > attached patch removes attndims and typndims entirely. > some tests skipped in my local my machine, not skipped are all OK. I have been hoping for a patch links this because I feel the existence of these system columns is deceptive since we don't honor them properly. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com When a patient asks the doctor, "Am I going to die?", he means "Am I going to die soon?"