Re: About #13489, array dimensions and CREATE TABLE ... LIKE

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Bruno Bonfils <asyd(at)asyd(dot)net>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, sshang(at)pivotal(dot)io, Alexey Bashtanov <alexey(at)brandwatch(dot)com>
Subject: Re: About #13489, array dimensions and CREATE TABLE ... LIKE
Date: 2023-11-21 02:07:36
Message-ID: ZVwQ6Fyh2SghkXja@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

On Mon, Nov 20, 2023 at 09:04:21PM -0500, Tom Lane wrote:
> Bruce Momjian <bruce(at)momjian(dot)us> 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 <bruce(at)momjian(dot)us> https://momjian.us
EDB https://enterprisedb.com

Only you can decide what is important to you.

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2023-11-21 02:13:01 Re: About #13489, array dimensions and CREATE TABLE ... LIKE
Previous Message Tom Lane 2023-11-21 02:04:21 Re: About #13489, array dimensions and CREATE TABLE ... LIKE

Browse pgsql-hackers by date

  From Date Subject
Next Message Jeff Davis 2023-11-21 02:12:47 simplehash: SH_OPTIMIZE_REPEAT for optimizing repeated lookups of the same key
Previous Message Tom Lane 2023-11-21 02:04:21 Re: About #13489, array dimensions and CREATE TABLE ... LIKE