Re: Output clause for Upsert aka INSERT...ON CONFLICT

From: Thomas Munro <thomas(dot)munro(at)gmail(dot)com>
To: Anand Sowmithiran <anandsowmi2(at)gmail(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Output clause for Upsert aka INSERT...ON CONFLICT
Date: 2022-01-27 05:55:25
Message-ID: CA+hUKGLn-8fpHjDDbotX=A_uuAUP__JuPevLzd8hnogom=k_pQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Jan 27, 2022 at 5:54 PM Anand Sowmithiran <anandsowmi2(at)gmail(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Smith 2022-01-27 05:58:51 Re: row filtering for logical replication
Previous Message Masahiko Sawada 2022-01-27 05:51:38 Re: Skipping logical replication transactions on subscriber side