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

From: Peter Eisentraut <peter(at)eisentraut(dot)org>
To: jian he <jian(dot)universality(at)gmail(dot)com>, Paul A Jungwirth <pj(at)illuminatedcomputing(dot)com>
Cc: Chao Li <li(dot)evan(dot)chao(at)gmail(dot)com>, SATYANARAYANA NARLAPURAM <satyanarlapuram(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: FOR PORTION OF does not recompute GENERATED STORED columns that depend on the range column
Date: 2026-06-04 10:04:25
Message-ID: 152f375a-8474-4fe5-875b-b78962320515@eisentraut.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 28.05.26 05:23, jian he wrote:
> On Tue, May 26, 2026 at 6:23 AM Paul A Jungwirth
> <pj(at)illuminatedcomputing(dot)com> 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)".

I fixed that. In one case the test actually included both kinds of
generated columns, so I just removed the "stored".

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message vellaipandiyan sm 2026-06-04 10:08:19 [PATCH] DOCS: Distinguish table and index storage parameters
Previous Message Anthonin Bonnefoy 2026-06-04 10:00:56 Re: [PATCH v4] pg_stat_statements: Add last_execution_start column