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 1r5GAx-00CduE-LN for pgsql-hackers@arkaria.postgresql.org; Tue, 21 Nov 2023 02:07:43 +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 1r5GAw-00CFMH-AV for pgsql-hackers@arkaria.postgresql.org; Tue, 21 Nov 2023 02:07:42 +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 1r5GAw-00CFM7-0y for pgsql-hackers@lists.postgresql.org; Tue, 21 Nov 2023 02:07:42 +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 1r5GAt-007WiC-8V for pgsql-hackers@postgresql.org; Tue, 21 Nov 2023 02:07:41 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=momjian.us; s=2023062407; h=In-Reply-To:Content-Type:MIME-Version:References:Message-ID: Subject:Cc:To:From:Date:Sender:Reply-To:Content-Transfer-Encoding:Content-ID: Content-Description; bh=+eUMmkKhahPhL00xkgQajWxAdvJxxQTa3888/QHSwEs=; b=cBtfE YGkdkgaFdNvkxHBNL8Z5mNP8lCp15mcSF5wRVG+D0PxxOKG/brleAeNshvOCgC2Fz2cDEmdPPZMM/ +N6AJ3Tp6ACtwg+GxjUQtC8P5voI3ziz6Un0ZvxKyIWR7GoE0fP/sc/eMEoIFCj5HAhfZkEFE1O3g 1PW8YYoMUEauMr0b0wg+YLpCTjpnZjHBnc2C4vbwxvlje1YipEJJs5yDl7ysuxr8dD6yKLcl0ICyK M0mQbRsuAlAXVG6gwlRTEbmdKFtbx8AfP3f98ifAvrIHpQpwIlQG6G6UQ+i3pHJNn1V+Hxu95r+Ff aFA7LVD96bC6pJJN1OOZkkzUe8vRg==; Received: from bruce by momjian.us with local (Exim 4.96) (envelope-from ) id 1r5GAq-0044Op-0C; Mon, 20 Nov 2023 21:07:36 -0500 Date: Mon, 20 Nov 2023 21:07:36 -0500 From: Bruce Momjian To: Tom Lane Cc: Bruno Bonfils , PostgreSQL-development , sshang@pivotal.io, Alexey Bashtanov Subject: Re: About #13489, array dimensions and CREATE TABLE ... LIKE Message-ID: References: <1402391.1700532261@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1402391.1700532261@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, Nov 20, 2023 at 09:04:21PM -0500, Tom Lane wrote: > Bruce Momjian writes: > > I would like to apply this patch to master because I think our current > > deficiencies in this area are unacceptable. > > I do not think this is a particularly good idea, because it creates > the impression in a couple of places that we track this data, when > we do not really do so to any meaningful extent. Okay, I thought we could get by without tracking the CREATE TABLE AS case, but it is inconsistent. My patch just makes it less inconsistent. > > An alternate approach would > > be to remove pg_attribute.attndims so we don't even try to preserve > > dimensionality. > > I could get behind that, perhaps. It looks like we're not using the > field in any meaningful way, and we could simplify TupleDescInitEntry > and perhaps some other APIs. So should I work on that patch or do you want to try? I think we should do something. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you.