Re: distinguish update from insert (on conflict)

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Justin Pryzby <pryzby(at)telsasoft(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: distinguish update from insert (on conflict)
Date: 2019-05-23 04:25:34
Message-ID: 54f2f1f00aca3fed9e81b4f370c7e90192bc5062.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Justin Pryzby wrote:
> Is it still impossible to distinguish whether a row was inserted vs updated ?
>
> The latest I can see is here:
> https://wiki.postgresql.org/wiki/UPSERT#RETURNING_behavior
>
> ..but I'm hopeful that the 4 year old wiki page is out of date.

Maybe this answer can help you:

https://stackoverflow.com/a/39204667/6464308

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Thiemo Kellner 2019-05-23 05:46:39 Table inheritance over schema boundaries possible
Previous Message Ron 2019-05-23 01:07:19 Re: Centos : Load Average :OS Process Name : migration/1, migration/2 , migration/n