Horton

Re: FOR PORTION OF does not recompute GENERATED STORED columns that depend on the range column

Nathan Bossart <nathandbossart@gmail.com>

View thread
From: Nathan Bossart <nathandbossart@gmail.com>
To: Paul A Jungwirth <pj@illuminatedcomputing.com>
Cc: jian he <jian.universality@gmail.com>, Chao Li <li.evan.chao@gmail.com>, Peter Eisentraut <peter@eisentraut.org>, SATYANARAYANA NARLAPURAM <satyanarlapuram@gmail.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2026-05-12T20:34:18Z
Lists: pgsql-hackers 
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