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: ED4E30DD9C43D5118DFB00508BBBA76EB1654A@neptun.sonorys.at (view raw or flat)
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
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

Responses

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-2014 The PostgreSQL Global Development Group