Re: CREATE DOMAIN create two not null constraints

2025-06-01 Thread jian he
On Mon, Jun 2, 2025 at 12:13 AM Álvaro Herrera wrote: > > Hmm, I think it would be more consistent to reject the case of duplicate > constraints, instead of silently ignoring it. So you'd do it in the > loop that checks for constraints before creating anything, like > > > diff --git a/src/backend

Re: CREATE DOMAIN create two not null constraints

2025-06-01 Thread Álvaro Herrera
On 2025-Jun-01, jian he wrote: > 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? Hmm, I think it would be more consistent to reject the case of duplicate constraints, inst