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

Reply via email to