Re: FOR PORTION OF does not recompute GENERATED STORED columns that depend on the range column
jian he <jian.universality@gmail.com>
From: jian he <jian.universality@gmail.com>
To: Paul A Jungwirth <pj@illuminatedcomputing.com>
Cc: SATYANARAYANA NARLAPURAM <satyanarlapuram@gmail.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2026-04-22T01:11:18Z
Lists: pgsql-hackers
On Tue, Apr 21, 2026 at 11:00 PM Paul A Jungwirth <pj@illuminatedcomputing.com> wrote: > > On Mon, Apr 20, 2026 at 8:58 PM jian he <jian.universality@gmail.com> wrote: > > > > + updatedCols = > > + bms_add_member(updatedCols, > > + rangeAttno - FirstLowInvalidHeapAttributeNumber); > > > > Here, use "perminfo->updatedCols" not "updatedCols", otherwise segfault. > > The attached diff based on v5, fixes this issue. > > > > +ALTER TABLE temporal_partitioned_3 ADD COLUMN range_len int GENERATED > > ALWAYS AS (upper(valid_at) - lower(valid_at)) STORED; > > Slightly refactoring the tests will allow for easier comparison of > > range_len values. > > I can't reproduce a segfault. I don't see how that code would lead to > one. Can you share what you're doing to cause it? Simply running the > regression tests doesn't do it for me. > Sorry for the noise. After cleaning the cached build directory and rebuilding, there is now no issue. +#include "nodes/print.h" This should be removed from v5.
Commits
Same data as JSON:
GET /api/v1/messages/:b64id/commits
the thread's linked commits as JSON, with link sources.
API reference →
-
Small terminology fixes in comments
- f0aedc7cb0ed 19 (unreleased) landed
-
Require UPDATE permission on FOR PORTION OF column
- 7ac030d5b152 19 (unreleased) landed