Horton

Bug in CREATE TABLE .. LIKE .. INCLUDING STATISTICS?

Julien Tachoires <julien@tachoires.me>

View thread View on postgr.es
From: Julien Tachoires <julien@tachoires.me>
To: pgsql-bugs@lists.postgresql.org
Date: 2026-04-15T10:57:18Z
Lists: pgsql-bugs

Attachments

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.

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.

Best regards,

-- 
Julien Tachoires

Commits

  1. Fix attnum remapping in generateClonedExtStatsStmt()