Re: BUG #5989: Assertion failure on UPDATE of big value - Mailing list pgsql-bugs

From Kevin Grittner
Subject Re: BUG #5989: Assertion failure on UPDATE of big value
Date
Msg-id 4DAEEAC1020000250003CAB7@gw.wicourts.gov
Whole thread Raw
In response to Re: BUG #5989: Assertion failure on UPDATE of big value  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: BUG #5989: Assertion failure on UPDATE of big value  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tom Lane <tgl@sss.pgh.pa.us> wrote:

> Egad.  If that's it, my confidence in the amount of testing SSI
> has gotten has just dropped dramatically.

If I'm reading this correctly, it would appear that nobody has
updated anything to a TOASTed value in a build against HEAD in
testing *anything* in the last two and a half months.  And the
regression tests don't include a single UPDATE to a TOASTed value
anywhere.  That seems like a significant code coverage deficiency.

Attached is a patch to cure the latter of these.  I'm submitting
this separately since it seems a good idea regardless of what
happens with the related SSI issue.

It is, of course, no excuse for making a dumb mistake like that, but
it wouldn't have survived the day on my machine or Dan's, much less
been submitted as a patch or committed, with the attached general
test of update-to-TOAST functionality in the regression tests.

-Kevin


Attachment

pgsql-bugs by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: BUG #5989: Assertion failure on UPDATE of big value
Next
From: Tom Lane
Date:
Subject: Re: BUG #5989: Assertion failure on UPDATE of big value