Re: When IMMUTABLE is not. - Mailing list pgsql-hackers

From chap@anastigmatix.net
Subject Re: When IMMUTABLE is not.
Date
Msg-id 7d1504b9211a5c153491761f3d82ae53@anastigmatix.net
Whole thread Raw
In response to Re: When IMMUTABLE is not.  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-hackers
On 2023-06-15 10:19, David G. Johnston wrote:
> The failure to find and execute the function code itself is not a 
> failure
> mode that these markers need be concerned with.  Assuming one can 
> execute
> the function an immutable function will give the same answer for the 
> same
> input for all time.

That was the view I ultimately took, and just made PL/Java suppress that
SPI readonly flag when going to look for the function code.

Until that change, you could run into the not-uncommon situation
where you've just loaded a jar of new functions and try to use them
in the same transaction, and hey presto, the VOLATILE ones all work,
and the IMMUTABLE ones aren't there yet.

Regards,
-Chap



pgsql-hackers by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: When IMMUTABLE is not.
Next
From: Tom Lane
Date:
Subject: Re: When IMMUTABLE is not.