KÖPFERL Robert wrote:
> 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