Re: Problematic enforcement of "ERROR: functions in index predicate must be marked IMMUTABLE" - Mailing list pgsql-general

From Kyotaro Horiguchi
Subject Re: Problematic enforcement of "ERROR: functions in index predicate must be marked IMMUTABLE"
Date
Msg-id 20230711.163029.2291239725090453767.horikyota.ntt@gmail.com
Whole thread Raw
In response to Re: Problematic enforcement of "ERROR: functions in index predicate must be marked IMMUTABLE"  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
At Mon, 10 Jul 2023 21:28:12 -0400, Tom Lane <tgl@sss.pgh.pa.us> wrote in 
> In the end, adding such restrictions would just give a false sense
> of security, because there would always be gaps in whatever we did.
> As you quote from the documentation, volatility markings are a promise
> by the user to the system, not vice versa.  If you break your promise,
> you get to keep both pieces of whatever trouble ensues.

I agree to you, as I mentioned a-bit-too-late message..

regards.

-- 
Kyotaro Horiguchi
NTT Open Source Software Center



pgsql-general by date:

Previous
From: Gurjeet Singh
Date:
Subject: Re: how to return data from insert into ... on conflict ... returning ... into
Next
From: KK CHN
Date:
Subject: BI Reports and Postgres