Fix handling of CREATE DOMAIN with GENERATED constraint syntax

Peter Eisentraut <peter@eisentraut.org>

Commit: 84a67725cd11ffbd5c0e142b067ae90dc3e57270
Author: Peter Eisentraut <peter@eisentraut.org>
Date: 2024-12-03T13:32:45Z
Releases: 18.0
Fix handling of CREATE DOMAIN with GENERATED constraint syntax

Stuff like

    CREATE DOMAIN foo AS int CONSTRAINT cc GENERATED ALWAYS AS (2) STORED

is not supported for domains, but the parser allows it, because it's
the same syntax as for table constraints.  But CreateDomain() did not
explicitly handle all ConstrType values, so the above would get an
internal error like

    ERROR:  unrecognized constraint subtype: 4

Fix that by providing a user-facing error message for all ConstrType
values.  Also, remove the switch default case, so future additions to
ConstrType are caught.

Reported-by: Jian He <jian.universality@gmail.com>
Discussion: https://www.postgresql.org/message-id/CACJufxF8fmM=Dbm4pDFuV_nKGz2-No0k4YifhrF3-rjXTWJM3w@mail.gmail.com

Files

PathChange+/−
src/backend/commands/typecmds.c modified +7 −3

Discussion