Thread: idea for show connection user

In the tree of main form:

local
   database
      mydb
        aggregates
        functions
        languages
        operators
        sequences
        tables
        types
        views
        connections - this show all user connect in the specific
database
   group
   user
   connection - this show all user connect all database

The information is retive of view in pg_stat_activity. For more
inforation read a

PostgreSQL 7.2 Documentation "Chapter 10. Monitoring Database Activity"

Bye !!
Frank Lupo (Wolf) !!



--
Prendi GRATIS l'email universale che... risparmia: http://www.email.it/f

Sponsor:
Puglia Pocket: le ultime notizie, gratis, sul tuo sito; devi solo prenderlo

Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=314&d=18-3

> -----Original Message-----
> From: frank_lupo@email.it [mailto:frank_lupo@email.it]
> Sent: 18 March 2002 18:36
> To: pgadmin-hackers
> Subject: [pgadmin-hackers] idea for show connection user
>
>
> In the tree of main form:
>
> local
>    database
>       mydb
>         aggregates
>         functions
>         languages
>         operators
>         sequences
>         tables
>         types
>         views
>         connections - this show all user connect in the
> specific database
>    group
>    user
>    connection - this show all user connect all database
>

A useful facility, but I don't think the treeview is the right place for it.
The treeview represents database objects in pgSchema which connections
wouldn't be. I think the proper place would be as properties of the
pgDatabase & pgServer. Display would be in the associated dialogue, probably
on a dedicated tab.

Comments anyone?

Regards, Dave.