Re: Corruption with IMMUTABLE functions in index expression.

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Prabhat Sahu <prabhat(dot)sahu(at)enterprisedb(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Corruption with IMMUTABLE functions in index expression.
Date: 2021-10-11 15:47:55
Message-ID: CAKFQuwar6O7ijP3E051y4yOKKOQW91QMCqmQTGMwAxRcN1_nJA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

David J.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Stephen Frost 2021-10-11 16:05:04 Re: Proposal: allow database-specific role memberships
Previous Message David G. Johnston 2021-10-11 15:44:20 Re: Proposal: allow database-specific role memberships