Maybe I'm telling old stories... if so, it's just the case.
I enountered couriosities while working with DOMAINS
When defining an aditional CHECK-constraint, the generated SQL looks like
that:
>
-- Domain: msisdn_type
-- DROP DOMAIN msisdn_type;
CREATE DOMAIN msisdn_type
AS varchar(32)
CHECK CHECK ((VALUE)::text ~ '^\\d+'::text);
ALTER DOMAIN msisdn_type OWNER TO robert;
<
notice the twice CHECK.
------------------
USing the Grant-Assistand on Functions privileges are mixed up.
Selecting one or more funcs and adding a privilege "ALL"
results in a "GRANT EXECUTE" while EXECUTE results in a "REVOKE ALL"
needless to say that the middle checkbox is empty