Re: with and trigger

From: Geoff Winkless <pgsqladmin(at)geoff(dot)dj>
To: PegoraroF10 <marcos(at)f10(dot)com(dot)br>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: with and trigger
Date: 2019-05-29 12:23:10
Message-ID: CAEzk6fdXusx=6PeUvOgDpeQE7ScDT8OAYtBXq8fsfUd8=9ZOvQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 29 May 2019 at 12:52, PegoraroF10 <marcos(at)f10(dot)com(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Fabrízio de Royes Mello 2019-05-29 12:28:50 Re: with and trigger
Previous Message PegoraroF10 2019-05-29 11:52:38 with and trigger