Re: Use ctid in where clause in update from statement

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Use ctid in where clause in update from statement
Date: 2019-07-01 12:08:20
Message-ID: 19fcc76d-4f44-b6f0-da7c-ce2320785b6f@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dirk Mika 2019-07-01 12:13:25 Re: Use ctid in where clause in update from statement
Previous Message Achilleas Mantzios 2019-07-01 12:04:59 Re: Use ctid in where clause in update from statement