Re: support fast default for domain with constraints

From: jian he <jian(dot)universality(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: support fast default for domain with constraints
Date: 2025-03-24 11:14:27
Message-ID: CACJufxGs_A0mrq9StOFAkVnK9x1U_s0+KuybGKUt2VmspC90Hw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

hi.

rebase because of commit: 8dd7c7cd0a2605d5301266a6b67a569d6a305106
also did minor enhancement.

v4-0001 add function: ExecPrepareExprSafe and ExecInitExprSafe.
v4-0002 add function: DomainHaveVolatileConstraints
v4-0003 tests and apply fast default for domain with constraints.

v4-0003 table with empty rows aligned with master behavior.
also will do table rewrite if the new column is domain with volatile
check constraints,
so less surprising behavior.

Attachment Content-Type Size
v4-0001-soft-error-variant-of-ExecPrepareExpr-ExecInitExp.patch text/x-patch 3.9 KB
v4-0003-fast-default-for-domain-with-constraints.patch text/x-patch 14.8 KB
v4-0002-add-function-DomainHaveVolatileConstraints.patch text/x-patch 2.6 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message John Naylor 2025-03-24 11:34:45 Re: [PATCH] SVE popcount support
Previous Message Pavel Borisov 2025-03-24 10:46:07 Re: POC, WIP: OR-clause support for indexes