Postgres Pro
Downloads
Home   >   mailing lists

CREATE DOMAIN create two not null constraints - Mailing list pgsql-hackers

From jian he
Subject CREATE DOMAIN create two not null constraints
Date
Msg-id CACJufxFSC0mcQ82bSk58sO-WJY4P-o4N6RD2M0D=DD_u_6EzdQ@mail.gmail.com
Whole thread Raw
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Daniil Davydov
Date:
Subject: Re: Speedup truncations of temporary relation forks
Next
From: Tom Lane
Date:
Subject: Re: Missing pg_depend entries for constraints created by extensions (deptype 'e')