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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
