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
Both fixed in CVS, thanks for reporting.
Regards, Andreas
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html