Thank you, Tom, for this valuable information.
On Tue, 01 Sep 2020 11:02:01 -0400
1Tom Lane wrote:
> visibility rules are the same as for any other function. So the
> answer to the OP's question depends on the transaction's isolation
> level and (for typical PLs) on whether the function is VOLA
t's a hard question, then the answer will be even more
interesting...?
Thanks again,
Dirk Lattermann
On Tue, 25 Aug 2020 11:12:35 +0200
Dirk Lattermann wrote:
> Hello,
>
> I'd like to understand the visibility of data changes made by other
> transactions when executing SQL c
at using a lock might lead to a deadlock, but I'd
want to give it a try.
Thank you very much.
Dirk Lattermann