Postgres Pro
Downloads
Home   >   mailing lists

Re: Output clause for Upsert aka INSERT...ON CONFLICT - Mailing list pgsql-hackers

From Thomas Munro
Subject Re: Output clause for Upsert aka INSERT...ON CONFLICT
Date
Msg-id CA+hUKGLn-8fpHjDDbotX=A_uuAUP__JuPevLzd8hnogom=k_pQ@mail.gmail.com
Whole thread Raw
In response to Output clause for Upsert aka INSERT...ON CONFLICT  (Anand Sowmithiran <anandsowmi2@gmail.com>)
List pgsql-hackers
Tree view 
On Thu, Jan 27, 2022 at 5:54 PM Anand Sowmithiran <anandsowmi2@gmail.com> wrote:
> Is there any workaround to get this info ?

There's an undocumented trick:

https://stackoverflow.com/questions/34762732/how-to-find-out-if-an-upsert-was-an-update-with-postgresql-9-5-upsert

pgsql-hackers by date:

Previous
From: Masahiko Sawada
Date:
Subject: Re: Skipping logical replication transactions on subscriber side
Next
From: Peter Smith
Date:
Subject: Re: row filtering for logical replication