Re: Use ctid in where clause in update from statement - Mailing list pgsql-general

From Thomas Kellerer
Subject Re: Use ctid in where clause in update from statement
Date
Msg-id 19fcc76d-4f44-b6f0-da7c-ce2320785b6f@gmx.net
Whole thread Raw
In response to Re: Use ctid in where clause in update from statement  (Dirk Mika <Dirk.Mika@mikatiming.de>)
Responses Re: Use ctid in where clause in update from statement  (Dirk Mika <Dirk.Mika@mikatiming.de>)
List pgsql-general
> As you can see the trigger function is called for the row I try to
> insert, but you can also see that there's no tuple inserted but one
> conflicting.

Ah, right. 

Thinking about it, it _has_ to call any BEFORE trigger function 
as that might change values of the row to be inserted that 
could possibly change the outcome of the test. 







pgsql-general by date:

Previous
From: Achilleas Mantzios
Date:
Subject: Re: Use ctid in where clause in update from statement
Next
From: Dirk Mika
Date:
Subject: Re: Use ctid in where clause in update from statement