MIME-Version: 1.0
References: <20260415105718.tomuncfbmlt67oel@poseidon.home.virt>
In-Reply-To: <20260415105718.tomuncfbmlt67oel@poseidon.home.virt>
From: Srinath Reddy Sadipiralla <srinath2133@gmail.com>
Date: Thu, 16 Apr 2026 13:14:39 +0530
Message-ID: <CAFC+b6q4pF=BSdfOaagRcW74Nmnyz1UMgPcNKRJMFrAe7K3gHQ@mail.gmail.com>
Subject: Re: Bug in CREATE TABLE .. LIKE .. INCLUDING STATISTICS?
To: Julien Tachoires <julien@tachoires.me>, dgrowleyml@gmail.com
Cc: pgsql-bugs@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000f1dd57064f8f0124"
Archived-At: <https://www.postgresql.org/message-id/CAFC%2Bb6q4pF%3DBSdfOaagRcW74Nmnyz1UMgPcNKRJMFrAe7K3gHQ%40mail.gmail.com>
Precedence: bulk

--000000000000f1dd57064f8f0124
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hi Julien,

On Wed, Apr 15, 2026 at 7:47=E2=80=AFPM Julien Tachoires <julien@tachoires.=
me>
wrote:

> Hi,
>
> One of our customer is experiencing an issue when executing CREATE TABLE
> .. LIKE .. INCLUDING ALL; on 14, the following kind of error happens:
> ERROR: cache lookup failed for attribute X of relation ZZZZZZ
>
> It seems to come from generateClonedExtStatsStmt(): get_attname()
> appears to be called with an attribute number (attnum) that does not
> exist.
>

yeah, i was able to reproduce and also check the flow which is the same
as you mentioned.


>
> Please find attached 2 patches for the master branch, the first one adds
> a test that triggers the problem, the 2nd one is an attempt to fix it.
>

I think it's better to write a 4 column test, with this it covers both
cases of lookup either returning the wrong column name or errors
out when the attnum does not exist in the child, thoughts?

something like this ....

CREATE TABLE parent_like_stats (a int, b int, c int, d int);
ALTER TABLE parent_like_stats DROP COLUMN b;
CREATE STATISTICS s_parent ON a, c FROM parent_like_stats;
CREATE TABLE child_like_stats (LIKE parent_like_stats INCLUDING STATISTICS)=
;

other than this patches LGTM.


--=20
Thanks,
Srinath Reddy Sadipiralla
EDB: https://www.enterprisedb.com/

--000000000000f1dd57064f8f0124
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">Hi=C2=A0Julien,</div><br><div class=3D"gm=
ail_quote gmail_quote_container"><div dir=3D"ltr" class=3D"gmail_attr">On W=
ed, Apr 15, 2026 at 7:47=E2=80=AFPM Julien Tachoires &lt;<a href=3D"mailto:=
julien@tachoires.me">julien@tachoires.me</a>&gt; wrote:<br></div><blockquot=
e class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px s=
olid rgb(204,204,204);padding-left:1ex">Hi,<br>
<br>
One of our customer is experiencing an issue when executing CREATE TABLE<br=
>
.. LIKE .. INCLUDING ALL; on 14, the following kind of error happens:<br>
ERROR: cache lookup failed for attribute X of relation ZZZZZZ<br>
<br>
It seems to come from generateClonedExtStatsStmt(): get_attname()<br>
appears to be called with an attribute number (attnum) that does not<br>
exist.<br></blockquote><div><br>yeah, i was able to reproduce=C2=A0and also=
 check the flow which is the same<br>as you mentioned.<br>=C2=A0</div><bloc=
kquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:=
1px solid rgb(204,204,204);padding-left:1ex">
<br>
Please find attached 2 patches for the master branch, the first one adds<br=
>
a test that triggers the problem, the 2nd one is an attempt to fix it.<br><=
/blockquote><div><br>I think it&#39;s better to write a 4 column test, with=
 this it covers both<br>cases of lookup either returning the wrong column n=
ame or errors<br>out when the attnum does not exist in the child, thoughts?=
<br><br>something like this ....<br><br>CREATE TABLE parent_like_stats (a i=
nt, b int, c int, d int);<br>ALTER TABLE parent_like_stats DROP COLUMN b;<b=
r>CREATE STATISTICS s_parent ON a, c FROM parent_like_stats;<br>CREATE TABL=
E child_like_stats (LIKE parent_like_stats INCLUDING STATISTICS);<br><br>ot=
her than this patches LGTM.</div></div><div><br clear=3D"all"></div><div><b=
r></div><span class=3D"gmail_signature_prefix">-- </span><br><div dir=3D"lt=
r" class=3D"gmail_signature"><div dir=3D"ltr"><span style=3D"color:rgb(34,3=
4,34)">Thanks,</span><br style=3D"color:rgb(34,34,34)"><span style=3D"color=
:rgb(34,34,34)">Srinath Reddy Sadipiralla</span><br style=3D"color:rgb(34,3=
4,34)"><span style=3D"color:rgb(34,34,34)">EDB:=C2=A0</span><a href=3D"http=
s://www.enterprisedb.com/" style=3D"color:rgb(17,85,204)" target=3D"_blank"=
>https://www.enterprisedb.com/</a></div></div></div>

--000000000000f1dd57064f8f0124--