pgAdmin III commit: Don't send the Greenplum query for each user, but i - Mailing list pgadmin-hackers

From Guillaume Lelarge
Subject pgAdmin III commit: Don't send the Greenplum query for each user, but i
Date
Msg-id 201008042136.o74La5mP010612@gothos.postgresql.org
Whole thread Raw
List pgadmin-hackers
Commit: http://git.postgresql.org/gitweb?p=pgadmin3.git;a=commitdiff;h=c99cc49a3eb40eb684ca185003522fba3b1d2723

Log Message
-----------
Don't send the Greenplum query for each user, but import it in the big roles query.

The CreateObjects() method launched a query to get all informations, but not
the Greenplum one. Then, another query is launched for every user if we are
connected to a Greenplum database. This patch merges the two query so that
only one query is launched.

Report from Little, Douglas. Patch from me. Checked by Chuck McDevitt.

Branch
------
REL-1_12_0_PATCHES

Modified Files
--------------
CHANGELOG                 |    2 ++
pgadmin/schema/pgRole.cpp |   35 ++++++++++++++++++++++-------------
2 files changed, 24 insertions(+), 13 deletions(-)


pgadmin-hackers by date:

Previous
From: "pgAdmin Trac"
Date:
Subject: [pgAdmin III] #221: A Greenplum query is executed once per role
Next
From: Guillaume Lelarge
Date:
Subject: Re: Patch on roles query for pgAdmin with a Greenplum database