pgsql: Relax overly strict sanity check for upgraded ancient databases - Mailing list pgsql-committers

From Alvaro Herrera
Subject pgsql: Relax overly strict sanity check for upgraded ancient databases
Date
Msg-id E1erVTy-0005Ln-8g@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Relax overly strict sanity check for upgraded ancient databases

Commit 4800f16a7ad0 added some sanity checks to ensure we don't
accidentally corrupt data, but in one of them we failed to consider the
effects of a database upgraded from 9.2 or earlier, where a tuple
exclusively locked prior to the upgrade has a slightly different bit
pattern.  Fix that by using the macro that we fixed in commit
74ebba84aeb6 for similar situations.

Reported-by: Alexandre Garcia
Reviewed-by: Andres Freund
Discussion: https://postgr.es/m/CAPYLKR6yxV4=pfW0Gwij7aPNiiPx+3ib4USVYnbuQdUtmkMaEA@mail.gmail.com

Andres suspects that this bug may have wider ranging consequences, but I
couldn't find anything.

Branch
------
REL9_5_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/491bbc36ea8f206dd0e03687b4d6a773be43a5f9

Modified Files
--------------
src/backend/access/heap/heapam.c | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)


pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql: Fix IOS planning when only some index columns can return anattr
Next
From: Tom Lane
Date:
Subject: pgsql: Use ereport not elog for some corrupt-HOT-chain reports.