pgsql: Extend DomainHasConstraints() to optionally check constraint vol

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Extend DomainHasConstraints() to optionally check constraint vol
Date: 2026-03-12 22:06:31
Message-ID: E1w0oAp-003fmV-2Q@gemulon.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Extend DomainHasConstraints() to optionally check constraint volatility

Add an optional bool *has_volatile output parameter to
DomainHasConstraints(). When non-NULL, the function checks whether any
CHECK constraint contains a volatile expression. Callers that don't
need this information pass NULL and get the same behavior as before.

This is needed by a subsequent commit that enables the fast default
optimization for domains with non-volatile constraints: we can safely
evaluate such constraints once at ALTER TABLE time, but volatile
constraints require a full table rewrite.

Author: Jian He <jian(dot)universality(at)gmail(dot)com>
Reviewed-by: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Reviewed-by: Andrew Dunstan <andrew(at)dunslane(dot)net>
Reviewed-by: Viktor Holmberg <viktor(dot)holmberg(at)aiven(dot)io>
Discussion: https://postgr.es/m/CACJufxE_+iZBR1i49k_AHigppPwLTJi6km8NOsC7FWvKdEmmXg@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/487cf2cbd2f5a32cf9756eb9bd6dbf9f3956c8b7

Modified Files
--------------
src/backend/commands/copyfrom.c | 2 +-
src/backend/commands/tablecmds.c | 4 ++--
src/backend/executor/execExpr.c | 2 +-
src/backend/optimizer/util/clauses.c | 2 +-
src/backend/parser/parse_expr.c | 2 +-
src/backend/utils/cache/typcache.c | 27 +++++++++++++++++++++++++--
src/include/utils/typcache.h | 2 +-
7 files changed, 32 insertions(+), 9 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Jeff Davis 2026-03-13 01:15:09 Re: pgsql: CREATE SUBSCRIPTION ... SERVER.
Previous Message Álvaro Herrera 2026-03-12 18:23:35 pgsql: Document the 'command' column of pg_stat_progress_repack