MIME-Version: 1.0
Date: Thu, 15 Jun 2023 10:25:46 -0400
From: chap@anastigmatix.net
To: "David G. Johnston" <david.g.johnston@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Yura Sokolov <y.sokolov@postgrespro.ru>,
 pgsql-hackers@lists.postgresql.org
Subject: Re: When IMMUTABLE is not.
In-Reply-To: <CAKFQuwbcsPwm_iiE8p5TYZ=2AEnt4LHpCnjjHYoCRAuZk9tzFw@mail.gmail.com>
References: <389c986d-fbb4-c644-9280-db7836af7ca9@postgrespro.ru>
 <2111925.1686835298@sss.pgh.pa.us>
 <69234e25e34e68425f49630f79ef9991@anastigmatix.net>
 <4c32f84bc097dee0081e4cc3e733ef8d@anastigmatix.net>
 <CAKFQuwbcsPwm_iiE8p5TYZ=2AEnt4LHpCnjjHYoCRAuZk9tzFw@mail.gmail.com>
User-Agent: Roundcube Webmail/1.6.0
Message-ID: <7d1504b9211a5c153491761f3d82ae53@anastigmatix.net>
Content-Type: text/plain; charset=US-ASCII;
 format=flowed
Content-Transfer-Encoding: 7bit
Archived-At: <https://www.postgresql.org/message-id/7d1504b9211a5c153491761f3d82ae53%40anastigmatix.net>
Precedence: bulk

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