Skip site navigation (1) Skip section navigation (2)

Bugs in PgadminIII 1.3.0 beta (7.1.05)

From: KÖPFERL Robert <robert(dot)koepferl(at)sonorys(dot)at>
To: pgadmin-support(at)postgresql(dot)org
Subject: Bugs in PgadminIII 1.3.0 beta (7.1.05)
Date: 2005-01-13 16:57:38
Message-ID: (view raw or whole thread)
Lists: pgadmin-support
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
-- 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


pgadmin-support by date

Next:From: Dan LangilleDate: 2005-01-13 19:16:50
Subject: pgadmin3 cores on FreeBSD 5.3
Previous:From: Andreas PflugDate: 2005-01-13 12:18:25
Subject: Re: pgadmin Bogus Varno: 3

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group