Thread: Bugs in PgadminIII 1.3.0 beta (7.1.05)

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

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