Horton
Menu

Re: How do I upsert depending on a second table?

David G. Johnston <david.g.johnston@gmail.com>

View thread
From: "David G. Johnston" <david.g.johnston@gmail.com>
To: Samuel Marks <samuelmarks@gmail.com>
Cc: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Date: 2025-09-23T21:31:46Z
Lists: pgsql-general 
On Tuesday, September 23, 2025, Samuel Marks <samuelmarks@gmail.com> wrote:

>
>
$subject

You can only upsert/provoke a meaningful conflict on the singular table
being inserted into.

There are other features like functions and triggers that may get you
something usable.

David J.