Re: Corruption with IMMUTABLE functions in index expression.

On 10/11/21 18:08, Andrey Borodin wrote:
> 
> 
>> 11 окт. 2021 г., в 20:47, David G. Johnston <david.g.johnston@gmail.com> написал(а):
>>
>> On Monday, October 11, 2021, Prabhat Sahu <prabhat.sahu@enterprisedb.com> wrote:
>> While using IMMUTABLE functions in index expression, we are getting below corruption on HEAD.
>>
>> That function is not actually immutable (the system doesn’t check whether your claim of immutability and the
functiondefinition match, its up to you to know and specify the correct label for what the function does) so not our
problem. Write a trigger instead.
 
> +1, but the error is strange. This might be a sign of some wrong assumption somewhere. My wild guess is that metapage
isread before it was written.
 
> 

True, but I can't reproduce it. So either the build is broken in some 
way, or perhaps there's something else going on. What would be quite 
helpful is a backtrace showing why the error was triggered. i.e. set a 
breakpoint on the ereport in mdread().


regards

-- 
Tomas Vondra
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company