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 1wSRMB-003BOg-1u for pgsql-hackers@arkaria.postgresql.org; Thu, 28 May 2026 03:24: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 1wSRM9-00Awzn-0Q for pgsql-hackers@arkaria.postgresql.org; Thu, 28 May 2026 03:24: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 1wSRM8-00Awzf-2k for pgsql-hackers@lists.postgresql.org; Thu, 28 May 2026 03:24:25 +0000 Received: from mail-vs1-xe2b.google.com ([2607:f8b0:4864:20::e2b]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wSRM7-000000016lQ-3H5n for pgsql-hackers@lists.postgresql.org; Thu, 28 May 2026 03:24:24 +0000 Received: by mail-vs1-xe2b.google.com with SMTP id ada2fe7eead31-6313c800372so9688425137.0 for ; Wed, 27 May 2026 20:24:23 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1779938663; cv=none; d=google.com; s=arc-20240605; b=CBmjb0eHucaZ+KWPbMsngWs3eyObSJoxREO5KGQX/E7145cd7a1ZjNBskkX2mIbq5g tq49NflRKpEao+AKk78XetaX8r8LxaP5Wv9HROGHx6KceQPlztv26PrV2l8LZZL/vYab +S0VLXXxK1XN/y7AoGW1/qXvQGeE6KCra7hUUUV4yoi9opqWWzDTkZA3ADRQMXv+guuR Nu6rA4v/NDMgMcQvAYdre848qaHHsMlqI5JfX6KVgNUtcd1bHoGxBzTi4nQ/88dMEP/M znba1oqznW3KrvsOorWbVQix3IUcwPh3cONblDjvqwY9r9knbIt0ua00N8eGCvPYfIBi mc0g== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=q0OlN0HbEiNBAOrr8Ei+fp7viZIob/bl5NJJZl4Uwo8=; fh=VYUpTPYLxUw8NRgo2U2kId46/cbh1PMrd08B8QyOzqo=; b=fPbi2l5aY3wQPIqh8opptKNj4C8/5omPtQ/eiv6mD0IcLXKXBztxyWPR+yuaj8uE/M Tt14OSUO/3n51X1I4QryO6jFVbDhdU/Cek9sBKBNrI9aTRXOgyS5Yta5P//N/krmqwiR 1Zcwv9Dvzday/MzcwRLgrteBHrWZcpp/scN1p2FozjUOtsPzvfv+Nukd5ZsWmcDFsdUJ KeSe8jGa6XX1jMiLAayVveh4E50yOOv4mek4HGD15R4A+soWdDQmGvHDiFRfzvQ5Qvh8 xs16O66U6nqhXjfk+6JUkcqt7fmOCPgP/U4u5AJMUqC+UptHilMDGs2wsTcwgYLuNWNN piWQ==; 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=1779938663; x=1780543463; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=q0OlN0HbEiNBAOrr8Ei+fp7viZIob/bl5NJJZl4Uwo8=; b=qpLfsUz0ZUvIi2Gn8rn3UW6G3Ebso/vaByaTXDBadoMgA5wewIWgiK61pJ5szNWaPA A2Z00lrhoelpkS+r6HstPsEI3oW6zM9LaVGnxoBzvbQIdsS5cLSegJUCGy0457/Np5/e +gc39EJyB0WG96L4qpzX2Z1+n0A955c8T65AfGFOgj0mEPORRGPDufl8VL/kSicPAerA jNS6+qakzxyScZCJyqBbLFGenIOzUvFloiiAAFbsIGWKZD878YgujOlLfdWViduR6neK MSqaiqTOobsCYShZK03l/eLPKl9eZ3YZy5avz9nGW4ztURIqqqFNtY9C23HTK40ZaLa7 4aMQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1779938663; x=1780543463; h=content-transfer-encoding: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=q0OlN0HbEiNBAOrr8Ei+fp7viZIob/bl5NJJZl4Uwo8=; b=avVkseRkKPExVJOWgBlrzFnYzD8aiirhxMpiuITIj89Ag/oQLKyPemYQujsxkz10bO pjixPHnnndzuZKO9v+3AgLuS3bD04Ex7JuHhrFeO/VT/9k/Lof4/Pp8RMbOSk47NwS0Z kwBwa7kg2pFLikErXWkQjnXS59zLdT5czEHry7FZY8jr0Rc2vFwcPhpZfJdJcCu5wrnr 5+nwmfCuEp5+dZmUOIErZJ5fZ5M6gz8KX1oUi2QXEwZgW8f2bUrEb1dzl9F8MScVR3h5 bxk40txZstgsTRljcZp62cffi9KcdwUGVr4YN9gayAPf2III5KHh6TK85000tig7xQRi nLmw== X-Forwarded-Encrypted: i=1; AFNElJ+OhyRIJLwUPS6ZoO+vzlUtu7f4wzv29l91r5vaZrqbAr+Hk6G0VDAMYK994XKWonb3yXLvNFjsnIhUjJRV@lists.postgresql.org X-Gm-Message-State: AOJu0YwGy4P16Ch9nGS9Gk9hyBhzNCz6h8C2r9ETwkkliigpZtz2HqH4 tT6HLjBRGeqbqSThv9IlpzTzupDlqUjalR54OcPhb/sRTaYeVk3Ga99NknZvUh9GI4lnHqLZKqZ ty349wje/6qt45UfcjZVIrkJBhUiU6Qg= X-Gm-Gg: Acq92OG21RDvuQO+Er+vnyFsaT3rLqYRCR2qBEiYwu/vRz+ELbnSaQsP392O0StikCY PYmSsHAi+xoTD+93Lins4D9G635dgWg60rfA6aU3pYLiOCnEqEXpZ6iHcwKEJ1QuPE7Vg5Jy7rC cQ6YmnLYTO1BgbLDDscpJHcXaSa4Y3L0qMeTM5BlLwZ+vfksRtasZglrpuTsF+bi04wVxQJRHXg Ib6h5JWnhCl1gM2QhphliXuoxdxIuJlcgiwoj3ehZe3HCqnNjkjKKwWl32Gww6MQxHYC4Cjor3T qsQ1KXBze6CoDHjmOBh8SxiQZ/TpromAolCsAPezBSbAT2wI6lKyjnDE3VN2ZRIS7cnzvgo3BqC 66qP2HRWYeebPoZFd8ZB/KbhhW0KVkXELlB9IDgXtRh25aBB9IuzHGWVqGFlLTpv3VEI8yCkbx2 Dhvv9z5naMnu+nepEtbfucRQfr3A7Skf0= X-Received: by 2002:a05:6102:3ed5:b0:631:2624:e5ec with SMTP id ada2fe7eead31-67c7c07917fmr15015689137.16.1779938662910; Wed, 27 May 2026 20:24:22 -0700 (PDT) MIME-Version: 1.0 References: <27BD5D23-19C9-4FD1-8935-9C788C3C9869@gmail.com> <66C1555B-CA54-4ED1-AB4F-0EE97D24A006@gmail.com> <91B35E0F-5DC1-4417-A1B9-FAF4A3DCD2BD@gmail.com> <74C1863C-2C2A-423A-BDE7-0228889F1D80@gmail.com> In-Reply-To: From: jian he Date: Thu, 28 May 2026 11:23:45 +0800 X-Gm-Features: AVHnY4LrQAfSpMlnioDMcWY4gMpAWiUn4hK4sCb8tMiy-r_6oL5XgwzwV3GPM1E Message-ID: Subject: Re: FOR PORTION OF does not recompute GENERATED STORED columns that depend on the range column To: Paul A Jungwirth Cc: Chao Li , Peter Eisentraut , SATYANARAYANA NARLAPURAM , PostgreSQL Hackers Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, May 26, 2026 at 6:23=E2=80=AFAM Paul A Jungwirth wrote: > > Here is a patch adding the application-time column to updatedCols, > along with the tests we've written for GENERATED columns and UPDATE OF > triggers. > V13 looks good to me. one minor issue: V13 uses the wording "generated stored column(s)", but all other places use "stored generated column(s)".