Re: with and trigger - Mailing list pgsql-general

From Geoff Winkless
Subject Re: with and trigger
Date
Msg-id CAEzk6fdXusx=6PeUvOgDpeQE7ScDT8OAYtBXq8fsfUd8=9ZOvQ@mail.gmail.com
Whole thread Raw
In response to with and trigger  (PegoraroF10 <marcos@f10.com.br>)
Responses Re: with and trigger
List pgsql-general
On Wed, 29 May 2019 at 12:52, PegoraroF10 <marcos@f10.com.br> 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

pgsql-general by date:

Previous
From: PegoraroF10
Date:
Subject: with and trigger
Next
From: Fabrízio de Royes Mello
Date:
Subject: Re: with and trigger