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

Re: Comments on roles and tablespaces for pg 8.2+

From: "Hiroshi Saito" <z-saito(at)guitar(dot)ocn(dot)ne(dot)jp>
To: "Erwin Brandstetter" <brandstetter(at)falter(dot)at>
Cc: <pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: Comments on roles and tablespaces for pg 8.2+
Date: 2007-08-02 01:18:23
Message-ID: 054101c7d4a3$053c1590$c601a8c0@HP22720319231 (view raw or flat)
Thread:
Lists: pgadmin-hackers
Hi.

Yes!, Only the tablespace was fixed. However, Role also includes a design,
please wait for it for a while.  Thanks!

Regards,
Hiroshi Saito

----- Original Message ----- 
From: "Erwin Brandstetter" <brandstetter(at)falter(dot)at>
To: <pgadmin-hackers(at)postgresql(dot)org>
Sent: Thursday, August 02, 2007 5:08 AM
Subject: [pgadmin-hackers] Comments on roles and tablespaces for pg 8.2+


> Hi developers!
>
> Testing pgAdmin III 1.8.0  Beta 2 (Jul 25 2007, rev: 6486). Client Win XP, host: Debian 
> Etch / PG 8.2.4
>
> pg 8.2 has added COMMENTs on two more objects: roles and tablespaces.
>    http://www.postgresql.org/docs/8.2/static/sql-comment.html  (compare with: 
> http://www.postgresql.org/docs/8.1/static/sql-comment.html)
>
>    COMMENT ON ROLE my_role IS 'Administration group for finance tables';
>    COMMENT ON TABLESPACE my_tablespace IS 'Tablespace for indexes';
>
> As I have to manage lots of users I find comments on roles especially useful. pgAdmin, 
> however, does not yet display these in the SQL pane of the object browser. One might 
> overwrite existing ones by accident, being mislead into thinking there were none.
>
> There is even a "Comment" field in the properties dialogue for tablespaces, but it does 
> not display existing comments and you cannot enter anything, either.
> There is no "Comment" field in in the properties dialogue for roles, yet.
>
> I would be content if the comments were shown in the SQL pane. Being able to edit them via 
> properties dialogue would be a bonus, IMO.
>
>
> The only new place for comments in pg 8.3 would be this one: (according to 
> http://developer.postgresql.org/pgdocs/postgres/sql-comment.html)
>    OPERATOR FAMILY /object_name/ USING /index_method
> /Not sure whether that requires any changes to pgAdmin./
> /
>
> For reference:
> psql (v 8.2.4) displays the comments. I demonstrate with "psql -E" to show the used SQL 
> (German version):
> There is still  \du+ or \dg+ for users / groups. Both display all roles these days (they 
> should probably update the docs or, better yet, substitute \du and \dg with \dr ...)
>
> event=# \du+
> ******** ANFRAGE *********
> SELECT r.rolname AS "Rollenname",
>  CASE WHEN r.rolsuper THEN 'ja' ELSE 'nein' END AS "Superuser",
>  CASE WHEN r.rolcreaterole THEN 'ja' ELSE 'nein' END AS "Rolle erzeugen",
>  CASE WHEN r.rolcreatedb THEN 'ja' ELSE 'nein' END AS "DB erzeugen",
>  CASE WHEN r.rolconnlimit < 0 THEN CAST('keine Beschränkung' AS pg_catalog.text)
>       ELSE CAST(r.rolconnlimit AS pg_catalog.text)
>  END AS "Verbindungen",
>  ARRAY(SELECT b.rolname FROM pg_catalog.pg_auth_members m JOIN pg_catalog.pg_roles b ON 
> (m.roleid = b.oid) WHERE m.member = r.oid) as "Mitglied von"
> , pg_catalog.shobj_description(r.oid, 'pg_authid') AS "Beschreibung"
> FROM pg_catalog.pg_roles r
> ORDER BY 1;
> **************************
>
> --  tablespaces:
> event=# \db+
> ******** ANFRAGE *********
> SELECT spcname AS "Name",
>  pg_catalog.pg_get_userbyid(spcowner) AS "Eigentümer",
>  spclocation AS "Pfad",
>  spcacl as "Zugriffsrechte",
>  pg_catalog.shobj_description(oid, 'pg_tablespace') AS "Beschreibung"
> FROM pg_catalog.pg_tablespace
> ORDER BY 1;
> **************************
>
>
> Regards
> Erwin
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>               http://archives.postgresql.org 


In response to

Responses

pgadmin-hackers by date

Next:From: svnDate: 2007-08-02 01:20:46
Subject: SVN Commit by hiroshi: r6524 - trunk/pgadmin3/pgadmin/schema
Previous:From: svnDate: 2007-08-02 01:14:37
Subject: SVN Commit by hiroshi: r6523 - in trunk/pgadmin3/pgadmin: dlg schema

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