Re: cataloguing NOT NULL constraints - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: cataloguing NOT NULL constraints
Date
Msg-id 1310237123.9823.1.camel@vanquo.pezone.net
Whole thread Raw
In response to cataloguing NOT NULL constraints  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: cataloguing NOT NULL constraints  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-hackers
On tor, 2011-07-07 at 17:34 -0400, Alvaro Herrera wrote:
> The attached patch introduces pg_constraint rows for NOT NULL
> column constraints.

The information schema views check_constraints and table_constraints
currently make up some artificial constraint names for not-null
constraints.  I suppose this patch removes the underlying cause for
that, so could you look into updating the information schema as well?
You could probably just remove the separate union branches for not null
and adjust the contype conditions.



pgsql-hackers by date:

Previous
From: Josh Kupershmidt
Date:
Subject: psql: display of object comments
Next
From: Darren Duncan
Date:
Subject: Re: [GENERAL] Creating temp tables inside read only transactions