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 1wMto8-000QXd-1i for pgsql-hackers@arkaria.postgresql.org; Tue, 12 May 2026 20:34:24 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wMto7-005ppk-0w for pgsql-hackers@arkaria.postgresql.org; Tue, 12 May 2026 20:34:23 +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 1wMto6-005ppb-36 for pgsql-hackers@lists.postgresql.org; Tue, 12 May 2026 20:34:23 +0000 Received: from mail-oo1-xc36.google.com ([2607:f8b0:4864:20::c36]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wMto4-00000000G7A-2lg4 for pgsql-hackers@lists.postgresql.org; Tue, 12 May 2026 20:34:22 +0000 Received: by mail-oo1-xc36.google.com with SMTP id 006d021491bc7-6966f99716fso3085750eaf.0 for ; Tue, 12 May 2026 13:34:21 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1778618060; x=1779222860; darn=lists.postgresql.org; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:from:to:cc:subject:date:message-id:reply-to; bh=GIdr1DTo3CIfTJ6B0+/FZTH4C24t0qnhLMECPtepVHg=; b=owH64xwWjvGO86oNIM42guRniGjKF4Dms6g22BeprOgwXqYx67ZatWHOjvWg2z2smN +LfQG3gwWhc0nakPQX3Q21o8jnWbuwZtLZ91hTjfR4wIf4U5MJFBFjxXX15eLueYhiJD LX6/IdVBX1OKHZlhxBMtT0zHWoYjlfeOMsL63QNePzQKzKHcuH8wfIMfmIkwBT5aI83R 9gUvFRGxSeyFv7NLfXCzwzNddNYkuCHz8VjY1FQZ3AX5K5kmmYYIY55yZDUF1kG/Lt7M k3KBLhti/OD5AA53eVQ1FesrlMwKAoW3GTEC1m6b6e/Uy0d/QOdKlX9PiRxS30GC2DJ6 yQFQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1778618060; x=1779222860; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:x-gm-gg:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=GIdr1DTo3CIfTJ6B0+/FZTH4C24t0qnhLMECPtepVHg=; b=gDBVybH6Ygbjg8MQKUzEf7L7E8BNVTwMsLVwUlZqMmA46Y1+jXwGxPbcumjsc3fy9u ob0NS4ntA5r9RBwWsDXr7bJwpRq7XZDLi30dlwAaVl8jXecMlgfLSbxbFb7Z0TLQ0Qep T0gfWq4UpWq3dvZ1X3GZs1kpsiZlBhfPea0ndtxeYGhr5baNdaZ6wilng526aGSHcrQF ynLid75O3yEVf5k1VOoqMD7iz31MCFQmNEX+r5LrcaDuIyopJ5kCft4JWFv4I64UGBUg 8oVEx782pSbLcjRB8x3oLvFTW6UGdBexgEK0WXYGfpT2Qinmit0IqpZxqfFWRhy6BXJ0 72DA== X-Forwarded-Encrypted: i=1; AFNElJ9vOK9YdD7Ony3xis6STyHmQxvyHZMv/6IDqN7hWAbnPvnzoWlZ8iOKjD+ncE39uVvemXX/eg5eXcQvqHc3@lists.postgresql.org X-Gm-Message-State: AOJu0YyutiDKrtrcYkr9fJtbC3ZPoJBcheaq9f/OevyQzL6l/bTk2xbE CwC7ItjsvZHPXHL2v2+4tq7U9oILT2rEUOm2j+m1/Na9EewRtYN8+xKp X-Gm-Gg: Acq92OHPvBsFe6abq8dfgHltjykgVymdT/dVoFciJRQSDP+xEUS937GwIqYHFi+ap5/ tABqOM0NPZXs7j6n+nju38CwtvTXh7WnI0tMvSLnGo7ohhd/ZcnHGoNoB/BZZ9j2O1k2767TPqp oulAo3mfObCdz5N/shXf+SX+49bDKBjar7Wpg1I45iTEvap1EA06+zT0H1OGxTOfAOA/RAk9AMp ciJQZQk/qqFwWwKLoGRNusXvKZcHs0Pwgt8QnHnoOMzq5zGCQqBkeJf3OwLoXmYezWM1JIWTlwm rnlxT+OiUaqwpt21uAZktSrhBcodPqQOLHq0T1NEnVhOkQPkpclM07m50hL4Wj2053dp/wFBh5f KHcHz2PuQsQMCx6OkhZcqaZSUmIoFSrNwdEhTzwyLpk1m0W/mwWM6HqPtroe2d4S6fXa4dbRCSf jeBJOzU8vHWdnAW3v3scf+FAaBhZs2mNw4tLrAxd3YSzjn7uj6X+RXoLt6LXkKL7unscnzUD4yH x19ovcvQEuLHZVs0zXuMA== X-Received: by 2002:a05:6820:2110:b0:696:8278:c619 with SMTP id 006d021491bc7-69b78d49a3cmr255356eaf.6.1778618060440; Tue, 12 May 2026 13:34:20 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id 586e51a60fabf-439c1e0b5easm868450fac.3.2026.05.12.13.34.19 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 12 May 2026 13:34:20 -0700 (PDT) Date: Tue, 12 May 2026 15:34:18 -0500 From: Nathan Bossart To: Paul A Jungwirth Cc: jian he , Chao Li , Peter Eisentraut , SATYANARAYANA NARLAPURAM , PostgreSQL Hackers Subject: Re: FOR PORTION OF does not recompute GENERATED STORED columns that depend on the range column Message-ID: 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> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk FOR PORTION OF doesn't seem to work well with virtual generated columns, either. The following example seg-faults on my machine: create table t (a int, b int4range generated always as (int4range(a, a + 1)) virtual); insert into t values (1); delete from t for portion of b from 1 to 2; -- nathan