Re: The suppress_redundant_updates_trigger() works incorrectly

Поиск
Список
Период
Сортировка
От Andrew Dunstan
Тема Re: The suppress_redundant_updates_trigger() works incorrectly
Дата
Msg-id 4911E683.3050703@dunslane.net
обсуждение исходный текст
Ответ на Re: The suppress_redundant_updates_trigger() works incorrectly  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers

Tom Lane wrote:
> 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?
>
>             
>   

OK, I guess I assumed we had a private copy.

Next thought is to split the memcmp() into two to avoid the Oid field, 
where it's present. I was hoping to avoid the kinda ugly arithmetic.

cheers

andrew


В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Jonah H. Harris"
Дата:
Сообщение: Re: broken URL in commitfest page
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: The suppress_redundant_updates_trigger() works incorrectly