Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1v1Ac6-005Hwb-MD for pgsql-general@arkaria.postgresql.org; Tue, 23 Sep 2025 21:31:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1v1Ac5-008Pck-BM for pgsql-general@arkaria.postgresql.org; Tue, 23 Sep 2025 21:31:53 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1v1Ac4-008Pcc-VE for pgsql-general@lists.postgresql.org; Tue, 23 Sep 2025 21:31:53 +0000 Received: from mail-oo1-xc2f.google.com ([2607:f8b0:4864:20::c2f]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1v1Ac0-002VMP-3D for pgsql-general@lists.postgresql.org; Tue, 23 Sep 2025 21:31:52 +0000 Received: by mail-oo1-xc2f.google.com with SMTP id 006d021491bc7-6218b52be5cso1681268eaf.0 for ; Tue, 23 Sep 2025 14:31:50 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1758663108; x=1759267908; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=9DN8RQrTOLbUkA794lImiEYyfj3Jafl8myCAt6X+dr4=; b=bgRr1yyLfNV7OOPF7lLOasis6d9weEuQQGV/G8l9S/zP+joljg/Jaydr92ruKygrDQ 1Y2epnjN7cUUh2eRzI0efLyhGsCSzsIeLInt3pneVBqvKrql7W8b+rcFt3gaZq8JC1UR HC51MP16dO2A7pEfXJ0fTro+IFsOwDJxwG1rlS3c/NTKJFlRYU+R7Fj1yEHGNpVLs8yf +xg8LunwG7JZc5BCAwLVrbzkHJTlau0h8+HX30sM2U15sLzPliu1JEKx8+zn297AN6N1 VJY3AOFz4VVUJfmiEWa9hkQmCqTsXuf04AriSm1dNFOfrNyHd6QHNUFr3sM7ZmMbWXyQ qO0g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1758663108; x=1759267908; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=9DN8RQrTOLbUkA794lImiEYyfj3Jafl8myCAt6X+dr4=; b=X6nUO8jIcrmV+KQRundUS2nhGUjkwiltoThfiIenrGeFB92ZQ+ERwpDHSRTgu7PN1s oGk13VuLNT4HIjUZmhc0v9R4rrmOTCLLR/+JSfM27XX+zrNGn2pCCk6n37GUmJkpv/TR CI+KQP2q/+iJ8kuxt3I/TuQYY1+ZtjzaHmTB/QPrn8ywg81e0fM3IqQJow9XLN+xC3rD uo//c2D6xuv7aoWcIK5zOkH/tBe6RRIgStUZREvBVhamTsp0YZzGz+hmmCj6XLogaFra mvI5wGzEj6I2a+GGt1e/O/G+PItlTz9mkAEK//9mc0TYzCFsp8J+bpcBiCXfu9ZcNbpn Y55A== X-Gm-Message-State: AOJu0YwITxN+8cXlbiFDcSY5kO6jIf+H0qDV1ywicYTSZwMMBi3bmhAn ch5+uTsdbRIjwVoN1yVfZ0PG9vJV2hbsBiK2YuQbBZvSvg9VgBeCod6dcKkI2mqKLuO/3jM0bHI f2h3zlw6PcrKbbz+L/n8XWtWOrBNoZS0= X-Gm-Gg: ASbGncsvbEnrTscbkhhDOiPxG96RvP0XLLtWyAU5TxX0jVWMteJEF9B6pMy7DJ4zRD+ scYmIdHyAb+diOhD7prFuUy27ErLHOfq5sSnOPXaZxGOfTijlt929XlPB9M3S7JIutsJHvhQVsx 4cP/5WTOji/VQvGkmx8I/erlie8VFDfDyShGXO79IjIoeKmmVOyHZifbsd4QpoxtvYVWkB80X/X oqH X-Google-Smtp-Source: AGHT+IHpMlR5Xre/git9L+3LN5t3hZTq1/rGYRiJ+dQQWekQrXiDiY3y30opCsIKMGjpc5kGEBeqELMMMd1fMnAGajk= X-Received: by 2002:a05:6808:14c3:b0:43d:1db5:665d with SMTP id 5614622812f47-43f2d28d630mr2003829b6e.4.1758663108285; Tue, 23 Sep 2025 14:31:48 -0700 (PDT) MIME-Version: 1.0 Received: by 2002:a05:6802:361b:b0:5f3:5bf6:6b0b with HTTP; Tue, 23 Sep 2025 14:31:46 -0700 (PDT) In-Reply-To: References: From: "David G. Johnston" Date: Tue, 23 Sep 2025 15:31:46 -0600 X-Gm-Features: AS18NWBRfTQGiiIIHEP7S0-47VhpwtvYHhdmg0c2c2Hpjksy7BAgx3YfYIMHV4A Message-ID: Subject: Re: How do I upsert depending on a second table? To: Samuel Marks Cc: "pgsql-general@lists.postgresql.org" Content-Type: multipart/alternative; boundary="000000000000d95c10063f7ea924" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000d95c10063f7ea924 Content-Type: text/plain; charset="UTF-8" On Tuesday, September 23, 2025, Samuel Marks 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. --000000000000d95c10063f7ea924 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Tuesday, September 23, 2025, Samuel Marks <samuelmarks@gmail.com> wrote:


$subject

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

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

--000000000000d95c10063f7ea924--