Re: update behavior

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: update behavior
Date: 2025-06-23 17:29:50
Message-ID: 75D7FBDF-0E82-476F-A5F7-DCE56F6D9B45@elevated-dev.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> On Jun 19, 2025, at 12:29 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> I believe we fire ON UPDATE triggers when an INSERT ON CONFLICT
> takes an UPDATE action, so it should do what you want.

Tested, and confirmed, this morning.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message DINESH NAIR 2025-06-23 19:02:19 Re: 'Sharing' data across different database.
Previous Message Valere Binet 2025-06-23 13:11:30 Re: FATAL: connection requires a valid client certificate