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 1u9mtq-006KAu-L1 for pgsql-general@arkaria.postgresql.org; Tue, 29 Apr 2025 15:29:35 +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 1u9mto-008Dai-Ld for pgsql-general@arkaria.postgresql.org; Tue, 29 Apr 2025 15:29:33 +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 1u9mto-008Da5-AA for pgsql-general@lists.postgresql.org; Tue, 29 Apr 2025 15:29:33 +0000 Received: from mail-oa1-x29.google.com ([2001:4860:4864:20::29]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1u9mtn-000Ci8-0k for pgsql-general@lists.postgresql.org; Tue, 29 Apr 2025 15:29:32 +0000 Received: by mail-oa1-x29.google.com with SMTP id 586e51a60fabf-2d4e7797d59so2997962fac.0 for ; Tue, 29 Apr 2025 08:29:30 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1745940569; x=1746545369; 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=Ci4q6bxalaWKv1GLH5JzXsZd8z9CW3Sgr+0VpAlgt4s=; b=cSSO8DmHnDRGVvpuSAXg3s63MKHe36YFhro303gxvfoXvOubq2uJReVpdwESRpfzE2 NjJMrhASZZzgliLyjZ9tzfnBComs1dEUxStzxo39MIOfLUT/uqiDD3W1mOk8+DcjKEVr KXJD1wL2R5P4e5fVRJX2o4XO3WhE5L8gVUqKth2rXAlSxM2uu2fAaoUHKShZIN0/gHay 4WEQTn59t6TcSRmrw2pobRcFwODy9sEE485sViBcxEM1WvqlLmSM8+7ViGVFuxmLblt1 6q6JTGAKOcaw8TklJTe+PAnSE98WPplW5crvhgXeXxGIriOpROtZkbSZbYPWGtniXhkX Pj7A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1745940569; x=1746545369; 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=Ci4q6bxalaWKv1GLH5JzXsZd8z9CW3Sgr+0VpAlgt4s=; b=aesxVZ4d/yR9cbBuWa1L+iidetJyJyYy5h7R5rpspSl6Lg/fiepFbLk9nh0mzTciwb pacmeydiWjMkK504otVNenAMD2IVdvQPr4P7q0tFdum8Li2EFL5FPOKjeEKZw+ISi5nn PWaHVytlqcKjYptDI6qrm4LoAlICg2mtxmshEzLGL/fRYKOBOSqksBx0ohRgH33GZKtK tGi81Ja288H7LZMiS9EAbGRxdhoVIyiuSwvC7HaONYJkXfi3Kl2SkwnyUX/EZd2zH3nQ ahCiYQ55eMXmSLHD2Hpq82kEJ4E0umiZpbBfUIUjsQtBU/WB7SVnNqbMD8X1BohOio7G HWuA== X-Forwarded-Encrypted: i=1; AJvYcCXLSbQLyWBzY91qSpyG7vUAYvaWUQ7/qAeJFOuGCTN8ls8JzyaO8kcp5MToNeg/CcXg9RxTc+VysrIN98zI@lists.postgresql.org X-Gm-Message-State: AOJu0YyulUEYQopTzvDqviDmgSSNsP9Kv00/hf2TRKR+rVg8X1xgfDhM +D/GcQJqE9KwGkcKI2uHedO880hH5vAltxkOwOy7VFi193+bIwfneR8kiEiqK6VAH8MeFDV2kKy OAaIpUligY4OPDvyo2Wd9msYZ+ys= X-Gm-Gg: ASbGnctqb62K0ZO8zETvti8J1nkErDXA2zUmr2fxscipRPZV51C0+fp1k63sOS4an+R 6DHW0bFLmnEX0wGNgNgIERDSGoSlgIkei2Q/N5ofrmsC66qcr7m2jK3tRLJde3SFG8soOe74A8f guRSQBM6J6ZZGdulHbKDH4 X-Google-Smtp-Source: AGHT+IE74ueZll2rhpH9wXl/jLkG3OCAJkz5lAYv+s7o4eRMSH/s7W2YuFWdpudM+3O6BT5OO4Ujx9mxJELwsmEtooI= X-Received: by 2002:a05:6870:b291:b0:2c1:7289:d62a with SMTP id 586e51a60fabf-2da4027b3b7mr2442296fac.36.1745940569166; Tue, 29 Apr 2025 08:29:29 -0700 (PDT) MIME-Version: 1.0 Received: by 2002:ac9:5bca:0:b0:589:13f9:e937 with HTTP; Tue, 29 Apr 2025 08:29:28 -0700 (PDT) In-Reply-To: References: <697017.1745837694@sss.pgh.pa.us> <80f95342-cc09-4236-a2d7-68538fbfc41b@wikimedia.org> <774865.1745848449@sss.pgh.pa.us> <5fe1d1c9-662e-405e-aaed-21d15bdbea06@wikimedia.org> <10ff0fbe7f4d711300951431ad28254aa5bf2dc4.camel@cybertec.at> From: "David G. Johnston" Date: Tue, 29 Apr 2025 08:29:28 -0700 X-Gm-Features: ATxdqUGkUW5rcrTTBnDBYR9LViPUB88XtRS9biljPwXRVHhytQoqrOS2oKhIkzg Message-ID: Subject: Re: Upsert error "column reference is ambiguous" To: Tim Starling Cc: Laurenz Albe , Tom Lane , "pgsql-general@lists.postgresql.org" Content-Type: multipart/alternative; boundary="0000000000006c97120633ec7746" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000006c97120633ec7746 Content-Type: text/plain; charset="UTF-8" On Tuesday, April 29, 2025, Tim Starling wrote: > > > This is a public interface and there may be callers in code that I don't > have access to. > You might help your cause by sharing examples of how client code uses your driver to perform upsert that runs into this limitation. David J. --0000000000006c97120633ec7746 Content-Type: text/html; charset="UTF-8" On Tuesday, April 29, 2025, Tim Starling <tstarling@wikimedia.org> wrote:

This is a public interface and there may be callers in code that I don't have access to.

You might help your cause by sharing examples of how client code uses your driver to perform upsert that runs into this limitation.

David J.

--0000000000006c97120633ec7746--