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 1sGyTU-001but-4z for pgsql-bugs@arkaria.postgresql.org; Tue, 11 Jun 2024 10:11:32 +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 1sGyTS-004uZu-PF for pgsql-bugs@arkaria.postgresql.org; Tue, 11 Jun 2024 10:11:31 +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 1sGxOK-004I8a-1A for pgsql-bugs@lists.postgresql.org; Tue, 11 Jun 2024 09:02:08 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sGxOI-0014um-Dp for pgsql-bugs@lists.postgresql.org; Tue, 11 Jun 2024 09:02:08 +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=yyUOOITTbvzAxkE9kFG/r/V+fNWfBd85rYp9/Bfbvco=; b=4skwx/HkZ7UoyB7QNDvTCp1Jsy USKhnFQ2DG6/XjzrDkUUMEJqpUDAJZFIUrf2OFh57uZWHBzTKrv6BSr4CME21p7ubOqQ0Vh7TkV94 G1153JVwI4OyjntxKGjgPrHURLoAfUxlAlWwFdUFjnniz4BkHg8Cny+FuT+EUurUhEoXBrGPCZqdy A/v397tpXUsMr9FtNF/81GvPhtADUXXQQhe41ha8YKIAep1D42ySOZMuxnOzrPkbCiz1CwCc/k6b9 ybrm65OUphs6Ekrb1g5GC9BYjKGTWsvl+/syzT4/Tmt3kEC/xgwEBGA/xy89WEya2T4QxF4XO8CI8 qdj3jgAw==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sGxOH-002SUC-1K for pgsql-bugs@lists.postgresql.org; Tue, 11 Jun 2024 09:02:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sGxOE-00EnNZ-Jj for pgsql-bugs@lists.postgresql.org; Tue, 11 Jun 2024 09:02:03 +0000 Content-Type: multipart/mixed; boundary="===============7082173269546606085==" MIME-Version: 1.0 Subject: BUG #18502: Upsert on view returns 42P10 error when condition is an expression To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: michael.wanghai.a@outlook.com Reply-To: michael.wanghai.a@outlook.com, pgsql-bugs@lists.postgresql.org Date: Tue, 11 Jun 2024 09:01:25 +0000 Message-ID: <18502-545b53f5b81e54e0@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 --===============7082173269546606085== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODUwMgpMb2dnZWQgYnk6ICAgICAgICAgIE1pY2hhZWwgV2FuZwpFbWFp bCBhZGRyZXNzOiAgICAgIG1pY2hhZWwud2FuZ2hhaS5hQG91dGxvb2suY29tClBvc3RncmVTUUwg dmVyc2lvbjogMTIuNQpPcGVyYXRpbmcgc3lzdGVtOiAgIE9mZmljaWFsIGRvY2tlciBJbWFnZSBy dW4gaW4gTWFjT1MgMTQuMwpEZXNjcmlwdGlvbjogICAgICAgIAoKSSBoYXZlIGEgdGFibGUsIGlu ZGV4IGFuZCB2aWV3IGxpa2UgZm9sbG93aW5nOg0KYGBgDQpDUkVBVEUgVEFCTEUgbXlfdGFibGUN CigNCiAgICBpZCAgIHV1aWQgcHJpbWFyeSBrZXksDQogICAgZGF0YSBqc29uYiBub3QgbnVsbA0K KTsNCkNSRUFURSBVTklRVUUgSU5ERVggT04gbXlfdGFibGUgKChkYXRhIC0+PiAna2V5JykpOw0K Q1JFQVRFIFZJRVcgbXlfdmlldyBBUyBTRUxFQ1QgKiBGUk9NIG15X3RhYmxlOw0KYGBgDQpUaGUg dXBzZXJ0IG9uIHZpZXcgcmV0dXJucyA0MlAxMCBlcnJvciB3aGVuIEkgZXhlY3V0ZSB0aGUgZm9s bG93aW5nIFNRTA0KYGBgDQpJTlNFUlQgSU5UTyBteV92aWV3IChpZCwgZGF0YSkNClZBTFVFUyAo Jzk5MGNjNzVjLTJlNjAtNGMwZC04YmVjLTlhYzk3NmRjMDNiYyc6OnV1aWQsDQogICAgICAgICd7 DQogICAgICAgICAgImtleSI6ICJ2YWx1ZSINCiAgICAgICAgfSc6Ompzb25iKQ0KT04gQ09ORkxJ Q1QgKChkYXRhIC0+PiAna2V5JykpDQogICAgRE8gTk9USElORzsNCmBgYA0KSSB0ZXN0ZWQgY2Fz dCBleHByZXNzaW9uIGFuZCBmYWlscyBhcyB3ZWxsDQpgYGANCkNSRUFURSBVTklRVUUgSU5ERVgg T04gbXlfdGFibGUgKChpZDo6dGV4dCkpOw0KSU5TRVJUIElOVE8gbXlfdmlldyAoaWQsIGRhdGEp DQpWQUxVRVMgKCc5OTBjYzc1Yy0yZTYwLTRjMGQtOGJlYy05YWM5NzZkYzAzYmMnOjp1dWlkLA0K ICAgICAgICAnew0KICAgICAgICAgICJrZXkiOiAidmFsdWUiDQogICAgICAgIH0nOjpqc29uYikN Ck9OIENPTkZMSUNUICgoaWQ6OnRleHQpKQ0KICAgIERPIE5PVEhJTkc7DQpgYGANCkkgYWxzbyB0 ZXN0ZWQgYERPIFVQREFURS4uLmAsIHRoZSBzYW1lIGVycm9yIGlzIHJldHVybmVkLg0KSSBhbHNv IHRlc3RlZCB3aXRoIHRoZSBsYXRlc3Qgb2ZmaWNpYWwgZG9ja2VyIGltYWdlIHdpdGNoIGlzIFBH IDE2LCBzYW1lCmVycm9yIHJldHVybnMuCgo= --===============7082173269546606085==--