Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lUzAr-0006ci-Oj for pgsql-bugs@arkaria.postgresql.org; Fri, 09 Apr 2021 22:00:22 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lUzAq-0002h0-5h for pgsql-bugs@arkaria.postgresql.org; Fri, 09 Apr 2021 22:00:20 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lUyja-0008BS-Pj for pgsql-bugs@lists.postgresql.org; Fri, 09 Apr 2021 21:32:11 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lUyjU-0003nm-D3 for pgsql-bugs@lists.postgresql.org; Fri, 09 Apr 2021 21:32:09 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=sanbXwQX2/CsjWP8RerHI7xfFIrWfi/8VrETHeobMyU=; b=vj+iJOMfZUG5PpOzCxHymlihm+ A5TjiDNx4pe3abpJQTh3E7KDEhgHsqRIVRLCYXHxmCxw8UI+0LUR7n2r8LFzwysqieKohriK0m7rk +tWdfxIY3NcEpjawO6xrT2kXVHay+akTLAqFR5qvrEEUcf1rl+YWtzjPlvQrX9mmp8h3uiz0qjecE 9m6Wu7mVa92hHYhUTrN2pQmc4vaXHh1hqrvVbKVdRiK1kq3XpY9I0OTpfe9CFJS4/fzCsY0WIPMNA gURvurWxJhDRWH7Jt5sV67yhSbfG0fgnCOwYpwgH7L0dk5/cmbJi2Mr9HubcIpc/tMo83TxfrhL8i j7qmqQyQ==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lUyjT-0000l9-S0 for pgsql-bugs@lists.postgresql.org; Fri, 09 Apr 2021 21:32:03 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lUyjS-00052W-Da for pgsql-bugs@lists.postgresql.org; Fri, 09 Apr 2021 21:32:02 +0000 Content-Type: multipart/mixed; boundary="===============0341486870031250565==" MIME-Version: 1.0 Subject: BUG #16958: "Invalid reference to FROM-clause entry for table" when qualifying columns in "on conflict .. where" To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: lukas.eder@gmail.com Reply-To: lukas.eder@gmail.com, pgsql-bugs@lists.postgresql.org Date: Fri, 09 Apr 2021 21:31:48 +0000 Message-ID: <16958-963f638020de271c@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============0341486870031250565== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjk1OApMb2dnZWQgYnk6ICAgICAgICAgIEx1a2FzIEVkZXIKRW1haWwg YWRkcmVzczogICAgICBsdWthcy5lZGVyQGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246IDEz LjIKT3BlcmF0aW5nIHN5c3RlbTogICBEb2NrZXIgb24gV2luZG93cwpEZXNjcmlwdGlvbjogICAg ICAgIAoKSSdtIHVzaW5nIERvY2tlciBvbiBXaW5kb3dzOg0KDQotLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQpzZWxlY3Qg dmVyc2lvbigpOw0KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KUG9zdGdyZVNRTCAxMy4yIChEZWJpYW4gMTMuMi0xLnBn ZGcxMDArMSkgb24geDg2XzY0LXBjLWxpbnV4LWdudSwgY29tcGlsZWQKYnkgZ2NjIChEZWJpYW4g OC4zLjAtNikgOC4zLjAsIDY0LWJpdA0KDQpDb25zaWRlciB0aGUgZm9sbG93aW5nIFNRTCBzY3Jp cHQ6DQotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tDQpjcmVhdGUgdGFibGUgdCAoDQogIGEgaW50LA0KICBiIGludCwNCiAg YyBpbnQNCik7DQoNCmNyZWF0ZSB1bmlxdWUgaW5kZXggaSBvbiB0KGEpDQp3aGVyZSB0LmIgaXMg bnVsbDsNCg0KaW5zZXJ0IGludG8gdCAoYSwgYikNCnZhbHVlcyAoDQogIDEsIA0KICAxDQopDQpv biBjb25mbGljdCAoYSkNCndoZXJlIHQuYiBpcyBudWxsIC0tIEVycm9yIGhlcmUNCmRvIHVwZGF0 ZQ0Kc2V0DQogIGMgPSAxDQpyZXR1cm5pbmcgdC5hLCB0LmIsIHQuYzsNCg0KZHJvcCB0YWJsZSB0 Ow0KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLQ0KDQpUaGVyZSdzIGFuIGVycm9yIHJlcG9ydGVkOg0KDQpTUUwgRXJyb3Ig WzQyUDAxXTogRVJST1I6IGludmFsaWQgcmVmZXJlbmNlIHRvIEZST00tY2xhdXNlIGVudHJ5IGZv ciB0YWJsZQoidCINCiAgSGludDogVGhlcmUgaXMgYW4gZW50cnkgZm9yIHRhYmxlICJ0IiwgYnV0 IGl0IGNhbm5vdCBiZSByZWZlcmVuY2VkIGZyb20KdGhpcyBwYXJ0IG9mIHRoZSBxdWVyeS4NCiAg UG9zaXRpb246IDcxDQoNCk5vdGljZSB0aGUgcXVhbGlmaWNhdGlvbiBvZiB0aGUgdC5iIGNvbHVt biBpbiB0aGUgIm9uIGNvbmZsaWN0IC4uIHdoZXJlIgpjbGF1c2UuIEkgZG9uJ3QgdW5kZXJzdGFu ZCB3aHkgYiBjYW5ub3QgYmUgcXVhbGlmaWVkIGF0IHRoaXMgbG9jYXRpb24uIEl0CmNhbiBiZSBx dWFsaWZpZWQgaW4gdGhlIGluZGV4IGRlZmluaXRpb24sIGxvb2tzIGxpa2UgYSBidWcgdG8gbWUu Cgo= --===============0341486870031250565==--