Re: The suppress_redundant_updates_trigger() works incorrectly - Mailing list pgsql-hackers

From Tom Lane
Subject Re: The suppress_redundant_updates_trigger() works incorrectly
Date
Msg-id 434.1225908635@sss.pgh.pa.us
Whole thread Raw
In response to Re: The suppress_redundant_updates_trigger() works incorrectly  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: The suppress_redundant_updates_trigger() works incorrectly
Re: The suppress_redundant_updates_trigger() works incorrectly
List pgsql-hackers
Andrew Dunstan <andrew@dunslane.net> writes:
> The attached patch sets the OID to InvalidOid for the duration of the
> memcmp if the HEAP_HASOID flag is set, and restores it afterwards.

This method is utterly, utterly unacceptable; you're probably trashing
the contents of a disk buffer there.  Even assuming that there's zero
risk of a failure between the set and the restore, what if someone is in
process of writing the buffer to disk?  Or even just examining the old
tuple?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_standby could not open wal file after selecting new timeline
Next
From: Tom Lane
Date:
Subject: Re: The suppress_redundant_updates_trigger() works incorrectly