Re: Corruption with IMMUTABLE functions in index expression. - Mailing list pgsql-hackers

From Tomas Vondra
Subject Re: Corruption with IMMUTABLE functions in index expression.
Date
Msg-id 034eb9d6-4ac5-13e1-6e19-ae720dd88cb7@enterprisedb.com
Whole thread Raw
In response to Re: Corruption with IMMUTABLE functions in index expression.  (Andrey Borodin <x4mmm@yandex-team.ru>)
Responses Re: Corruption with IMMUTABLE functions in index expression.
List pgsql-hackers

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



pgsql-hackers by date:

Previous
From: Andrey Borodin
Date:
Subject: Re: Corruption with IMMUTABLE functions in index expression.
Next
From: Tom Lane
Date:
Subject: Re: Corruption with IMMUTABLE functions in index expression.