Re: Virtual generated columns

From: Peter Eisentraut <peter(at)eisentraut(dot)org>
To: Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, jian he <jian(dot)universality(at)gmail(dot)com>
Subject: Re: Virtual generated columns
Date: 2025-02-04 22:36:09
Message-ID: afb36e1f-8be9-4900-b29e-b095e30e9416@eisentraut.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 27.01.25 13:42, Dean Rasheed wrote:
> On Mon, 27 Jan 2025 at 09:59, Peter Eisentraut <peter(at)eisentraut(dot)org> wrote:
>>
>> Here is an updated patch that integrates the above changes and also
>> makes some adjustments now that the logical replication configuration
>> questions are resolved. I think this is complete now.
>>
>
> In struct ResultRelInfo, the following field is added:
>
> int ri_NumGeneratedNeededI;
> int ri_NumGeneratedNeededU;
>
> + /* true if the above have been computed */
> + bool ri_Generated_valid;
> +
>
> but that doesn't really seem to be accurate, because it's set to true
> by ExecInitGenerated() whether it's called with CMD_INSERT or
> CMD_UPDATE, so it will be true before both the other fields are
> computed. It's used from ExecGetExtraUpdatedCols() as an indicator
> that ri_extraUpdatedCols is valid, but it looks like that might not be
> the case, if ExecInitGenerated() was only called with CMD_INSERT.
>
> I'm not sure if that represents an actual bug, but it looks wrong. It
> should perhaps be called "ri_extraUpdatedCols_valid", and only set to
> true when ExecInitGenerated() is called with CMD_UPDATE, and
> ri_extraUpdatedCols is populated.

Yeah, this is quite contorted. I have renamed it like you suggested.

Attachment Content-Type Size
v14-0001-Virtual-generated-columns.patch text/plain 226.6 KB
v14-0002-Fixup-review-Shlok-Kyal-2025-01-28.patch text/plain 1.7 KB
v14-0003-Fixup-review-Dean-Rasheed-2025-01-27.patch text/plain 2.4 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2025-02-04 22:36:53 Re: Virtual generated columns
Previous Message Melanie Plageman 2025-02-04 22:34:46 Re: Eagerly scan all-visible pages to amortize aggressive vacuum