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