Re: Trigger transaction isolation

2020-09-02 Thread Dirk Lattermann
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

Re: Trigger transaction isolation

2020-09-01 Thread Dirk Lattermann
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

Trigger transaction isolation

2020-08-25 Thread Dirk Lattermann
at using a lock might lead to a deadlock, but I'd want to give it a try. Thank you very much. Dirk Lattermann