CREATE DOMAIN create two not null constraints

From: jian he <jian(dot)universality(at)gmail(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: CREATE DOMAIN create two not null constraints
Date: 2025-06-01 15:44:46
Message-ID: CACJufxFSC0mcQ82bSk58sO-WJY4P-o4N6RD2M0D=DD_u_6EzdQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

hi.

CREATE DOMAIN int_domain1 AS INT CONSTRAINT nn1 NOT NULL CONSTRAINT
nn2 NOT NULL;

will install two not-null pg_constraint entries.
we should have only one?

Attachment Content-Type Size
v1-0001-Fix-CREATE-DOMAIN-create-two-not-null-constraint.patch application/x-patch 3.1 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2025-06-01 16:04:13 Re: Missing pg_depend entries for constraints created by extensions (deptype 'e')
Previous Message Ryo Kanbayashi 2025-06-01 12:36:08 Re: [PATCH] PGSERVICEFILE as part of a normal connection string