Postgres Pro
Downloads
Home   >   mailing lists

Re: distinguish update from insert (on conflict) - Mailing list pgsql-general

From Justin Pryzby
Subject Re: distinguish update from insert (on conflict)
Date
Msg-id 20190522023748.GH4426@telsasoft.com
Whole thread Raw
In response to Re: distinguish update from insert (on conflict)  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: distinguish update from insert (on conflict)
Re: distinguish update from insert (on conflict)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: distinguish update from insert (on conflict)
Next
From: Luca Ferrari
Date:
Subject: pg_stat_user_tables.n_tup_ins empty for partitioned table