Re: distinguish update from insert (on conflict)

From: Justin Pryzby <pryzby(at)telsasoft(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: distinguish update from insert (on conflict)
Date: 2019-05-22 02:37:49
Message-ID: 20190522023748.GH4426@telsasoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, May 21, 2019 at 06:57:36PM -0700, Adrian Klaver wrote:
> On 5/21/19 6:34 PM, Justin Pryzby wrote:
> >Is it still impossible to distinguish whether a row was inserted vs updated ?
>
> You will need to be more specific.

Sorry, I mean with UPSERT / "INSERT .. ON CONFLICT DO UPDATE", is it possible
to tell whether a row was inserted vs. updated ?

Thanks,
Justin

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Luca Ferrari 2019-05-22 08:08:44 pg_stat_user_tables.n_tup_ins empty for partitioned table
Previous Message Adrian Klaver 2019-05-22 01:57:36 Re: distinguish update from insert (on conflict)