From: dutow (@dutow) <noreply+dutow@github.com>
To: reorg/pg_repack <noreply+reorg-pg_repack@github.com>
Subject: [reorg/pg_repack] PR #490: Ignore pg_attver in repack-check attoptions output
Date: Wed, 11 Nov 2026 12:59:55 +0000
Message-ID: <gh-reorg-pg_repack-490@github.com> (raw)
The November 2026 minor releases (14 to 19) store a per-column version in pg_attribute.attoptions as pg_attver=<LSN>, as part of the fix for unsafe deforming of composite datums. The value is server-internal and differs on every run, so filter it out of the column options check.
inline patch 1: regress/expected/repack-check.out, regress/expected/repack-check_1.out, regress/expected/repack-check_2.out and 2 more (+20/-5 lines) download inline-1.patchdiff --git a/regress/expected/repack-check.out b/regress/expected/repack-check.outindex 3925b09..16a8e8d 100644--- a/regress/expected/repack-check.out+++ b/regress/expected/repack-check.out@@ -127,7 +127,10 @@ SELECT oid, relname
(0 rows)
-- check columns options
-SELECT attname, nullif(attstattarget, -1) as attstattarget, attoptions+-- skip pg_attver, server-internal column version stored in attoptions+SELECT attname, nullif(attstattarget, -1) as attstattarget,+ nullif(array(SELECT o FROM unnest(attoptions) o+ WHERE o NOT LIKE 'pg\_attver=%'), '{}') as attoptions
FROM pg_attribute
WHERE attrelid = 'tbl_idxopts'::regclass
AND attnum > 0
diff --git a/regress/expected/repack-check_1.out b/regress/expected/repack-check_1.outindex ff7b527..2059df2 100644--- a/regress/expected/repack-check_1.out+++ b/regress/expected/repack-check_1.out@@ -127,7 +127,10 @@ SELECT oid, relname
(0 rows)
-- check columns options
-SELECT attname, nullif(attstattarget, -1) as attstattarget, attoptions+-- skip pg_attver, server-internal column version stored in attoptions+SELECT attname, nullif(attstattarget, -1) as attstattarget,+ nullif(array(SELECT o FROM unnest(attoptions) o+ WHERE o NOT LIKE 'pg\_attver=%'), '{}') as attoptions
FROM pg_attribute
WHERE attrelid = 'tbl_idxopts'::regclass
AND attnum > 0
diff --git a/regress/expected/repack-check_2.out b/regress/expected/repack-check_2.outindex 059c93c..6dd6b21 100644--- a/regress/expected/repack-check_2.out+++ b/regress/expected/repack-check_2.out@@ -127,7 +127,10 @@ SELECT oid, relname
(0 rows)
-- check columns options
-SELECT attname, nullif(attstattarget, -1) as attstattarget, attoptions+-- skip pg_attver, server-internal column version stored in attoptions+SELECT attname, nullif(attstattarget, -1) as attstattarget,+ nullif(array(SELECT o FROM unnest(attoptions) o+ WHERE o NOT LIKE 'pg\_attver=%'), '{}') as attoptions
FROM pg_attribute
WHERE attrelid = 'tbl_idxopts'::regclass
AND attnum > 0
diff --git a/regress/expected/repack-check_3.out b/regress/expected/repack-check_3.outindex 079a756..95d42a6 100644--- a/regress/expected/repack-check_3.out+++ b/regress/expected/repack-check_3.out@@ -127,7 +127,10 @@ SELECT oid, relname
(0 rows)
-- check columns options
-SELECT attname, nullif(attstattarget, -1) as attstattarget, attoptions+-- skip pg_attver, server-internal column version stored in attoptions+SELECT attname, nullif(attstattarget, -1) as attstattarget,+ nullif(array(SELECT o FROM unnest(attoptions) o+ WHERE o NOT LIKE 'pg\_attver=%'), '{}') as attoptions
FROM pg_attribute
WHERE attrelid = 'tbl_idxopts'::regclass
AND attnum > 0
diff --git a/regress/sql/repack-check.sql b/regress/sql/repack-check.sqlindex 1c3ef13..519e1f2 100644--- a/regress/sql/repack-check.sql+++ b/regress/sql/repack-check.sql@@ -44,7 +44,10 @@ SELECT oid, relname
AND reltoastrelid NOT IN (SELECT oid FROM pg_class WHERE relkind = 't');
-- check columns options
-SELECT attname, nullif(attstattarget, -1) as attstattarget, attoptions+-- skip pg_attver, server-internal column version stored in attoptions+SELECT attname, nullif(attstattarget, -1) as attstattarget,+ nullif(array(SELECT o FROM unnest(attoptions) o+ WHERE o NOT LIKE 'pg\_attver=%'), '{}') as attoptions
FROM pg_attribute
WHERE attrelid = 'tbl_idxopts'::regclass
AND attnum > 0