Re: domain over virtual generated column

On Mon, Apr 28, 2025 at 10:45 AM jian he <jian(dot)universality(at)gmail(dot)com> wrote:
>
> summary of attached patch:
> v1-0001
> we need to compute the generation expression for the domain with constraints,
> thus rename ExecComputeStoredGenerated to ExecComputeGenerated.
>
> v1-0002
> soft error variant of ExecPrepareExpr, ExecInitExpr. for soft error processing
> of CoerceToDomain. we don't want error messages like "value for domain d2
> violates check constraint "d2_check"" while validating existing domain data, we
> want something like:
> ERROR: column "b" of table "gtest24" contains values that violate the
> new constraint
>
> v1-0003 virtual generation columns over domain.

hi.

new patches attached.
mainly code refactoring, also try to reduce some unnecessary regress tests.