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.96) (envelope-from ) id 1whWt8-000HZ6-0p for pgsql-hackers@arkaria.postgresql.org; Wed, 08 Jul 2026 18:20:50 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1whWt6-008kcN-0s for pgsql-hackers@arkaria.postgresql.org; Wed, 08 Jul 2026 18:20:49 +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.96) (envelope-from ) id 1whWt5-008kcB-3D for pgsql-hackers@lists.postgresql.org; Wed, 08 Jul 2026 18:20:48 +0000 Received: from fhigh-a3-smtp.messagingengine.com ([103.168.172.154]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1whWt3-00000000K0X-2X0v for pgsql-hackers@lists.postgresql.org; Wed, 08 Jul 2026 18:20:48 +0000 Received: from phl-compute-06.internal (phl-compute-06.internal [10.202.2.46]) by mailfhigh.phl.internal (Postfix) with ESMTP id 9558614000DB; Wed, 8 Jul 2026 14:20:44 -0400 (EDT) Received: from phl-frontend-03 ([10.202.2.162]) by phl-compute-06.internal (MEProxy); Wed, 08 Jul 2026 14:20:44 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=eisentraut.org; h=cc:cc:content-transfer-encoding:content-type:content-type :date:date:from:from:in-reply-to:in-reply-to:message-id :mime-version:references:reply-to:subject:subject:to:to; s=fm1; t=1783534844; x=1783621244; bh=oPg6Euifl1eLEX+usLR6jTxW4231qq9q YGzbLRsRcIM=; b=vaYm0CmUZRN9yyasHRX2IyT/b6ES1deGkNEko26bSfyxOUA1 nlz6A0cXlmbA+fzGArYmbHsBM4U416oG7ZmaCQUyw9cMUHYvVyCpEe/U4d4vSGcU b501Cgpif2AQmnk/ZpX47sIXMV2uOpAA8VSqc9GmeTn17LC0iFQ8gELcsbz6fF45 vUX7gcc24MACsFpJoOvPkxML3GHliceo2tn3RSOqhtSjhVkLlCDPNO41yUWx0xSH gEvCjNnji2ixkScD1BHKYxBJZ6b4yqFvgYxj2hLl6OEu0JL9KfmaYWliD+IWOawI MMJyyS1pFHiQYJ3yOQQ/hPMe7i2n9tOWsVrAkg== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm2; t=1783534844; x= 1783621244; bh=oPg6Euifl1eLEX+usLR6jTxW4231qq9qYGzbLRsRcIM=; b=A 0cACDVOr0e49u7LEYXFCOXaFCPzbgang7VK80Hf1Vr0Mgl8r4MZfwRBPGe7fTdGD Vflg4F4PxHhNTo1+wSD3fAMFllyK0Cm57msmAqoH+8j3Fld5ofWFJ/xpIrcJSG0p n0SUhGnhCZ5GutkdJniJpcEP5AAOmfvOq5ZgCnR177rCwFRAqxOOVsAfSrvg4WX0 4DxhoYVTEZDW9TcJ6kOv+4VV5Yc9y4iBJzcxYq+BPzpeg20ipELs3RnYu1DzoEUQ 9oAzbwrIe/V/LvLqH6RdlJ3NfRQp4gAPhYoAwKrOIwbv/uZxLrPXU3+7hPFHeHC9 zMbXAsY6wLRmb81SmJGkg== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: dmFkZTEXdX3Av8Cdxz9m8RJZRg4He2MvP3JnbOtkBX7/TyLIbw+sQt1YByJ4a+VcOl1Hyt f37QbTBcCIg6AobgZXtdi7Fl4uHrLzHwvSMI2C6AhQGMhjTznJvrdg4plKqV+F2VDkRvSP KYfQu4Q14cfCQHpttDchOUEOsUFIrUgb/e+ldKEMw2PWVYdQE06O4AaJhwmU0ITaZMMLYU /8pc118hzOliBayai1HTX3ql6W/jLGERLWS4F3rSdFMs9Kmil+Kwq6QWTYhw6ihbrQNKLe 1eOdWHDZiUevKDoeMqTlnWx6UsZxZ/HiV7RGRzNVvz5hA23idVo1KKlQGgJv3H20PNELiC nq0zvb7vjib0czmyiJ9DI/SKsR6+SQjl9ILWJwmTEn4eOK1p4fqXO4SszVGAF2nyzUikNk psNTKlq3W+TKCWnFZiOOXmvy5Z0gg9EbFo1kkk8lLZXbMjFCvGZPP6rHCxNZFyBck0Kp3k e3o2yibwD/VCm9vEQzCCrH5gz2GrgHp3fSlAQgU71yHOPK9TTNvDSuFQB4Y6SKRIlezNqh ENx5tShr1eKDXyc9JPf8TyIxWFUwyHcCUNfGRyq3ul/AYkVd0+eLGiSrE5nf0JURzNlG0Y kNpUgxzlQP5NMwvlYq1h8DtD3UpAk7VwHtT1Lx6kxgcBw8JpqIiy6YUgnPAQ X-ME-Proxy: Feedback-ID: ie0a040ee:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed, 8 Jul 2026 14:20:43 -0400 (EDT) Message-ID: Date: Wed, 8 Jul 2026 20:20:43 +0200 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Fix SET EXPRESSION for virtual columns with whole-row dependencies To: Chao Li , jian he Cc: Postgres hackers References: <71242FEA-15A3-4073-9FA1-561CA744ACBD@gmail.com> <5B739323-C897-4B1A-9BFC-656E5CB4AD58@gmail.com> Content-Language: en-US From: Peter Eisentraut In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 10.06.26 11:12, Chao Li wrote: >> fter reading the other implementation in [1], I realized that I had missed the partial-index case, so I added coverage for that. >> >> I am still sending an updated version of this patch because my implementation is different from the one in [1]. I would like people to compare the two approaches and decide which direction is better. >> >> [1]https://postgr.es/m/ >> CAJTYsWXOkyeDVbzymWc9sKrq7Y_MUv6XJXN4H9GfsBOPd3NJ+w@mail.gmail.com >> >> Best regards, >> -- >> Chao Li (Evan) >> HighGo Software Co., Ltd. >> https://www.highgo.com/ >> >> > Oops! Forgot the attachment. Here comes it. This has been addressed via the patch in the other thread.