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 1waPw3-001mpM-1f for pgsql-hackers@arkaria.postgresql.org; Fri, 19 Jun 2026 03:30:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1waPw2-00EoV2-1W for pgsql-hackers@arkaria.postgresql.org; Fri, 19 Jun 2026 03:30:26 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1waPw2-00EoUm-0M for pgsql-hackers@lists.postgresql.org; Fri, 19 Jun 2026 03:30:26 +0000 Received: from mail-wr1-x431.google.com ([2a00:1450:4864:20::431]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1waPw0-0000000155i-1zXL for pgsql-hackers@lists.postgresql.org; Fri, 19 Jun 2026 03:30:24 +0000 Received: by mail-wr1-x431.google.com with SMTP id ffacd0b85a97d-462bb734793so1204927f8f.1 for ; Thu, 18 Jun 2026 20:30:23 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1781839822; cv=none; d=google.com; s=arc-20240605; b=DoBCB5ZAK6nrpniuXu+g5HZIChBmYz/WePjjvRQA7S3hBn318pW9citdPFBbl3SvsN lhVnZGvg/JfFz0mhbykjJFZKUhzE1cD3y3KLQ0DP4uCVFlyy39EZS3E7lezBrxRPtNAY 6MMF5GkdaqmRP4eFl+mS5GlW9ObcwdIkVFG7GHykyjwuK080iBDPhb+yGLayCOrJJGWg GPfD0r3XPyU76PFqy8L/D17byFT9Cp5/N5VtnYimcD9YCoPd6GHujF/gF8S4OPew+crb 85JXrj+rFapDPo9F/XWBMnNClRzSXLQcudp0QlW7krLgHlP/x7qm5ar33V7+uuHETE3V k0+A== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:dkim-signature; bh=4EgYITfknz7Jmq93XYPfkivu0aiCrB7EDAygBBkOy0g=; fh=Yudcmslt86/LNXBTr6Li40Myx7mNZhpnCODtjTOfnqg=; b=R2gw75qjOXIvwuOcsood0di6mVGgkcN/NwaR7FyehwQFHWoN9V9V/k/uLwJFE5ntUZ 1Cn/NzhlJcMm1EO8r8AzT3ckVGt1SqewvcI95CAw6f9NWFEV4VBjej7LQ2j8DDK4zWXF eDhOgrIRu8/xNAvxpAzyYwCg6BCGrinYs/mVHZoiYcQL+7M/u78QKCWnJBv07HEVhJ53 LIsAELvx/vQuz0xfBkKGKb4Pz4F6QV9pLBKpNNTIAu+RqzPqxlUVww/48CqwetiEU0FV AqisjrKMECoFrY5pDLl0KC3wfbL+d5/moQJ3afTKFFn3SB9Q5buoOzrVfVhEmm55uNMm Pptw==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1781839822; x=1782444622; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=4EgYITfknz7Jmq93XYPfkivu0aiCrB7EDAygBBkOy0g=; b=NjofFmMx3ewdUN4nYWzxam1IHih11d5KUKfzg6QE2oxqd/EJWEf9p/7F6Nsc6jRp0z iW7EYbzRA/ShPWoxb6hF0Ymv3FfI6IO22ASgAiihb6H92mGmzTSpGBQqtVfJXZYB93pd GbDUBfv1X+Gl2qwnpmRgMsKmygO9gicAyBkyywmwTCxRzr79l2sNG/X5A8KKxyyvhipz 9crGzw8ro5I6c2p7vfmddZEmbDlAxS9BYz2k5EU5wLh/yzkTeaJm3KBooItmpOVG1fJk T4BwyiGuPb7UMQZezbOUZ5WvmjINFBN0YFgJzoBf/1423DI++DZoE5hkvXPbyU0mERwC /Qbg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1781839822; x=1782444622; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=4EgYITfknz7Jmq93XYPfkivu0aiCrB7EDAygBBkOy0g=; b=Zu+J3zi4N8sFTIelpDA6qJu0AV+uhMq237waGPmZDYnITiuaHGOv73tUSkHU2foMFT evTTYFeK9uwBmCntUfs2A9qngt+8kaqiA44F9oja60SVx2+HuFqP4hsdcYVUbUiTwYHa rAh88fz1pZhVYeO69M6NfwxED/vZwKi6actO+uQ6o5Uop/06P7MZuAjJAL4rPSBdTFpi HNbGFLgLNoT51ijWHRP0qVXLGkU3wFhEFC/wcZVGTVI0vD2SAKt+zaRJauOe+TmbSuoi /dK0huhZJGys9aeLxvNXW7anXbYf1AQfLBg+AAMlmGmJ4vUoYNeA6gU4aOcShAPJtpAy tbew== X-Forwarded-Encrypted: i=1; AFNElJ92IdG4ZVYNH97L1VtwdnOzT7Fy7nWhzJWUuhPZDjYwfTyygCktY9tvbi9T/hPhJcfPaU+kuIS1o43EKuhO@lists.postgresql.org X-Gm-Message-State: AOJu0Ywk+L1i6Xr2zjiQWk3+YzYGmEy6omnIRra5+YnPBp0hSlZUBe8s raUBdtlJLnob6TzSiQVsqsUo62t/GYvxO8UeXB7BhC1Ceznn+oxIe80Q/4dMbrMCuDrbi+yzy+K uomwqap6AbrV/+ba20rmCIt77bfjC2W4= X-Gm-Gg: AfdE7clRa7ABc/cIYH0tcnx1Px/MKDkefQnd0n5jmP6+dPj+Vvp31T44nrARk9gn2bJ 2qrjes/SDHNIsTAk2VfxbMfbdKgDmG1QT1LH2wfPcVzUKyk8FQ2Cl5yGXPmgCI6oLk5VsACRHRg b0QXt4c4x0CRXKfdYpbDoko1j+Pp1Wsn2j1UzmE9q0UYbAvHily3WtjLIxjHp/zQXOQOGlijcmx AaErQi2NptuT0vQNbGzMOEN/VqR7dWPcbqRattUPWnA0nLFZZu+Q0/7QheGW1xIfJk0U8jlg7kx 5KAn8LvGw34xEIij3gVZgi3L/CoxiWiRAmDXQrk+Z66h2CjwO9CS30VzTVHISXpkPI5huCVX X-Received: by 2002:a5d:44c1:0:b0:460:1f34:cf80 with SMTP id ffacd0b85a97d-4650005c5bcmr2223850f8f.18.1781839822450; Thu, 18 Jun 2026 20:30:22 -0700 (PDT) MIME-Version: 1.0 References: <1151393.1781734980@sss.pgh.pa.us> <1174236.1781736349@sss.pgh.pa.us> <2A622929-A45C-4370-943A-BC76FF4CC433@gmail.com> <03C47613-5C89-4E69-BB72-3B2912BDDDA8@gmail.com> <96A79F87-ACDF-479F-B69D-0CACB7085C97@gmail.com> In-Reply-To: <96A79F87-ACDF-479F-B69D-0CACB7085C97@gmail.com> From: David Rowley Date: Fri, 19 Jun 2026 15:30:11 +1200 X-Gm-Features: AVVi8CfioN3begphL6yi8EtJ9j1OdDRvOUrze1GGGJIi4x6Jrvuys7nAK7_R0Uw Message-ID: Subject: Re: Fix tuple deformation with virtual generated NOT NULL columns To: Chao Li Cc: Tom Lane , Peter Eisentraut , Andres Freund , Postgres hackers Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, 18 Jun 2026 at 18:46, Chao Li wrote: > This version feels all set. Thanks for looking. I've pushed and backpatched this now. For the v18 version, I included the tests added by 1f7dfe8c8 in the same commit. I did it that way so as not to briefly introduce a test that would fail into REL_18_STABLE. David