Re: information_schema.check_constraints Inconsistencies

Hello,

I am writing with regards to some wrong results I keep on receiving when using check_constraints view from information_schema:

(1) First, it shows constraints grouped by name, regardless of the relation used: when having two constraints with the same name in different tables, it shows both in both tables, regardless of their belonging;

(2) Second, it also lists NOT NULL constraints, even though they are not created as check constraints.