On Wed, 29 May 2019 at 12:52, PegoraroF10 <marcos@xxxxxxxxxx> wrote:
This trigger will not work because Master record was not inserted yet.
That seems reasonable. Since the transaction is meant to be atomic any select within the query should return data from tables as they are at the start of the transaction, the insert won't happen (as far as the rest of the query is concerned) until it commits.
Or have I misunderstood what you're saying?
Geoff
