Re: Virtual generated columns - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Virtual generated columns
Date
Msg-id a6fa6f90-1fd8-471d-a6c5-dd70c76eeada@eisentraut.org
Whole thread Raw
In response to Re: Virtual generated columns  (jian he <jian.universality@gmail.com>)
Responses Re: Virtual generated columns
List pgsql-hackers
On 12.11.24 09:49, jian he wrote:
>> On Wed, Nov 6, 2024 at 12:17 AM Peter Eisentraut <peter@eisentraut.org> wrote:
> RelationBuildPartitionKey
> if (!isnull)
> {
>          char       *exprString;
>          Node       *expr;
>          exprString = TextDatumGetCString(datum);
>          expr = stringToNode(exprString);
>          pfree(exprString);
>          expr = expand_generated_columns_in_expr(expr, relation);
> }
> no need expand_generated_columns_in_expr?
> in ComputePartitionAttrs, we already forbidden generated columns to be
> part of the partition key.

True.  I have removed this extra code in v9.

> check_modified_virtual_generated, we can replace fastgetattr to
> heap_attisnull? like:
>              // bool        isnull;
>              // fastgetattr(tuple, i + 1, tupdesc, &isnull);
>              // if (!isnull)
>              //     ereport(ERROR,
>              //             (errcode(ERRCODE_E_R_I_E_TRIGGER_PROTOCOL_VIOLATED),
>              //              errmsg("trigger modified virtual generated
> column value")));
>              if (!heap_attisnull(tuple, i+1, tupdesc))
>                  ereport(ERROR,
>                          (errcode(ERRCODE_E_R_I_E_TRIGGER_PROTOCOL_VIOLATED),
>                           errmsg("trigger modified virtual generated
> column value")));

I don't know.  fastgetattr() is supposed to be "fast". ;-)  It's all 
inline functions, so maybe that is actually correct.  I don't have a 
strong opinion either way.




pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Virtual generated columns
Next
From: Peter Eisentraut
Date:
Subject: Re: Virtual generated columns