Re: Problem with TOAST column corruption - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Problem with TOAST column corruption
Date
Msg-id 24524.1009466800@sss.pgh.pa.us
Whole thread Raw
In response to Problem with TOAST column corruption  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> I have a /data directory from someone running 7.1.3 and they are seeing
> data corruption on a table using TOAST columns.

What is the complete schema of the table?  Could we see a dump of the
entire tuple not just the parts that the system thinks are toasted
fields?

Neither value looks plausible at all as a toasted datum, so I am
wondering if there is corruption of earlier columns in the row,
leading to an alignment problem (ie, length of some earlier varlena
item was misdetermined).
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: patch: INSERT INTO t VALUES (a, b, ..., DEFAULT, ...)
Next
From: "Pavlo Baron"
Date:
Subject: Re: patch: INSERT INTO t VALUES (a, b, ..., DEFAULT, ...)