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 1wYHSq-000AMs-0s for pgsql-hackers@arkaria.postgresql.org; Sat, 13 Jun 2026 06:03:28 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wYHRo-002mTV-0P for pgsql-hackers@arkaria.postgresql.org; Sat, 13 Jun 2026 06:02:24 +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 1wYHRn-002mTL-2T for pgsql-hackers@lists.postgresql.org; Sat, 13 Jun 2026 06:02:23 +0000 Received: from mail-pl1-x62d.google.com ([2607:f8b0:4864:20::62d]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wYHRj-000000008Zi-3mDY for pgsql-hackers@lists.postgresql.org; Sat, 13 Jun 2026 06:02:23 +0000 Received: by mail-pl1-x62d.google.com with SMTP id d9443c01a7336-2c0c3546924so11232885ad.3 for ; Fri, 12 Jun 2026 23:02:19 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1781330537; x=1781935337; darn=lists.postgresql.org; h=to:references:message-id:content-transfer-encoding:cc:date :in-reply-to:from:subject:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=RKIzlG2jc4DcFZRQkOJlfTLDFn/2MpA4tzgGs2fu4eQ=; b=pWbID1yh4ebBZJZAy09XkhCJvAXf7i75jrcfOd0wP8BB/AEtODElNXxkIFOWQrtBBb +kZ/XE1LXskgpvpUc7z2wW8sFhrKDbr4DJluUHO3SfI15eEPxZmgkIPEBuFJ4IhELYfR KV5UZe0VzslnKw2GgEz3j2CpgOnz0lS9W58ZRvJcim/Q4Dgkc/dTB0SvYZh0Cx/Cy5Oc 1OAO6yxaE8bJX/fsXQD/Hy+QRbYDyYfvQTqyEnHsp2LI12eOmvZvIADIq/zGLe17HQ7z Y07fwyrFmASI+6mXC0CvIPx0LX4FThnNm8efYyfYIGX3P5OnYhoHHcHtoS5gV5JhaiKD cmTw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1781330537; x=1781935337; h=to:references:message-id:content-transfer-encoding:cc:date :in-reply-to:from:subject:mime-version:x-gm-gg:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=RKIzlG2jc4DcFZRQkOJlfTLDFn/2MpA4tzgGs2fu4eQ=; b=dYPkt4R12REQEYBEQPtV0No19HVXK/1vdWvEjKRIY7+7LSEtKqd7gALB2ekiyHDZJe pkjOT6bYy+RvagYZqH5b9pypx1nM4byEJm0ATwJThMdqPil+A+OXBxC/cynBXw7KzpEF alPw4oHzNwT1anchW/QhmE/fN3rQfkcROUm/ua2u8Jqe/DMiUSc3MI2K/US5O66zwZPH jeGbfvdPs49ZxOvO3wStYgZWCnKJ3XkfDBVPaWyMpvJ64izTFYRooLGeHiEOhBuWG/Qz aphKb8uTsFZg+fFz+xQYPYN8HGpsIVXKFboISqRuR+Qqj6p2x3EC/uRsJadGw6vnXhBz 7jfg== X-Gm-Message-State: AOJu0YzL0YSUl0+/yGVoYGrZnak6jEGm4cS9QapAKoJDJPHOOsqnL0kW DfQnlK+j9Vt5qc9iItjzQz9Mk2mw5P1yhv5xpVVHuJ/vSzqyv6Ip78hp X-Gm-Gg: Acq92OFUZQwqCatZD1MVijk0ztxilyOApOCSBDLTN3T7Unx3hQVY+7WbqzPCumKqapx lWrq0ssg9CCe4FUA3LP8b8ZrrJ4XCBVkgUTcdXPoAAaG38srQnhnw0HGinDwi6BOa8GDkWULWxb ZEN1OjvFJJFHr+qBK6q/QFG/1hQwlv7LfRP6N/19SEFq4K70U0A0LDMQcWLemd0q+zVZDjeGA/Z pr5KYTNlZliRe9RoYGvSJQS0jN0e//3SP997GeN4u0oCKL20+66SEn2TzUpx1LvKcnSE1nmuZot cR1DjjoQxpBkND/3WW2RMTEWKLfyPiQT7PEpeyq2JOw6oN1WkIVCBf24J7xSEeDz1Mv4y2hYw77 An6g+1Rf8wbvzQUZrXl9tbNQ5QM4XCiwJsy/pQNxs7ifdfl82hOApgizQqBJV/TE1dp2b1FVYlF kxR324Wl1gjnhvpWdeb9WsYh1MJXX7FQMX X-Received: by 2002:a17:903:1a44:b0:2c0:bd28:bed5 with SMTP id d9443c01a7336-2c6641f1e05mr28276935ad.10.1781330536630; Fri, 12 Jun 2026 23:02:16 -0700 (PDT) Received: from smtpclient.apple ([185.135.79.161]) by smtp.gmail.com with ESMTPSA id d9443c01a7336-2c432c8dd4bsm38351975ad.60.2026.06.12.23.02.14 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Fri, 12 Jun 2026 23:02:16 -0700 (PDT) Content-Type: text/plain; charset=utf-8 Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3864.600.51.1.1\)) Subject: Re: Fix SET EXPRESSION for virtual columns with whole-row dependencies From: Chao Li In-Reply-To: Date: Sat, 13 Jun 2026 14:01:40 +0800 Cc: Postgres hackers , Peter Eisentraut Content-Transfer-Encoding: quoted-printable Message-Id: <65A70B05-E682-48AE-9EB2-D62ADBFB35D1@gmail.com> References: <71242FEA-15A3-4073-9FA1-561CA744ACBD@gmail.com> <5B739323-C897-4B1A-9BFC-656E5CB4AD58@gmail.com> To: jian he X-Mailer: Apple Mail (2.3864.600.51.1.1) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > On Jun 13, 2026, at 10:42, jian he = wrote: >=20 > On Wed, Jun 10, 2026 at 5:06=E2=80=AFPM Chao Li = wrote: >>=20 >>=20 >> After reading the other implementation in [1], I realized that I had = missed the partial-index case, so I added coverage for that. >>=20 >> 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. >>=20 >=20 > I tried your patch before but abandoned it due to many regression test = failures. >=20 Thanks for looking. But I wonder which tests I missed? I ran =E2=80=9Cmake check-world=E2=80=9D locally and passed. The CI = tests all passed on the CF: = https://commitfest.postgresql.org/patch/6867/ Best regards, -- Chao Li (Evan) HighGo Software Co., Ltd. https://www.highgo.com/