| From: | Andrey Borodin <x4mmm(at)yandex-team(dot)ru> |
|---|---|
| To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
| Cc: | Prabhat Sahu <prabhat(dot)sahu(at)enterprisedb(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Corruption with IMMUTABLE functions in index expression. |
| Date: | 2021-10-11 16:08:18 |
| Message-ID: | 654FE935-6110-4C5F-AE1E-A74E30DA1101@yandex-team.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> 11 окт. 2021 г., в 20:47, David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com> написал(а):
>
> On Monday, October 11, 2021, Prabhat Sahu <prabhat(dot)sahu(at)enterprisedb(dot)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 function definition 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 is read before it was written.
Best regards, Andrey Borodin.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tomas Vondra | 2021-10-11 16:26:09 | Re: Corruption with IMMUTABLE functions in index expression. |
| Previous Message | Stephen Frost | 2021-10-11 16:05:04 | Re: Proposal: allow database-specific role memberships |