-- tuple. Bloom filter must fingerprint normalized index tuple representation.

--

CREATE TABLE toast_bug(buggy text);

ALTER TABLE toast_bug ALTER COLUMN buggy SET STORAGE plain;

-- pg_attribute entry for toasty.buggy will have plain storage:

CREATE INDEX toasty ON toast_bug(buggy);

-- Whereas pg_attribute entry for toast_bug.buggy now has extended storage:

ALTER TABLE toast_bug ALTER COLUMN buggy SET STORAGE extended;

CREATE INDEX toasty ON toast_bug(buggy);

-- pg_attribute entry for toasty.buggy (the index) will have plain storage:

UPDATE pg_attribute SET attstorage = 'p'

WHERE attrelid = 'toasty'::regclass AND attname = 'buggy';

-- Whereas pg_attribute entry for toast_bug.buggy (the table) still has extended storage:

SELECT attstorage FROM pg_attribute

WHERE attrelid = 'toast_bug'::regclass AND attname = 'buggy';

attstorage

------------

x

(1 row)

-- Insert compressible heap tuple (comfortably exceeds TOAST_TUPLE_THRESHOLD):

INSERT INTO toast_bug SELECT repeat('a', 2200);

-- Should not get false positive report of corruption:

CREATETABLEtoast_bug(buggytext);

ALTERTABLE toast_bug ALTER COLUMN buggySET STORAGE plain;

CREATEINDEXtoastyON toast_bug(buggy);

ALTERTABLE toast_bug ALTER COLUMN buggySET STORAGE extended;

CREATEINDEXtoastyON toast_bug(buggy);

UPDATE pg_attributeSET attstorage='p'

WHERE attrelid='toasty'::regclassAND attname='buggy';

SELECT attstorageFROM pg_attribute

WHERE attrelid='toast_bug'::regclassAND attname='buggy';

INSERT INTO toast_bugSELECT repeat('a',2200);