pgAdmin III does not display Default Privileges for schemas

From: Nathan Alden <me(at)nathanalden(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: pgAdmin III does not display Default Privileges for schemas
Date: 2012-12-08 02:38:33
Message-ID: CAAoJjG2pToqHkW9V8UAr37Ey0Y5ahJoqK0Wj6edZqZ+eDVKZJg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Windows 7 x64
PostgreSQL 9.2.2
pgAdmin III 1.16.1

Follow these steps to reproduce:

1. Connect to the postgres DB.
2. Run the following SQL:

create database test_database;

3. Run the following SQL:

create role my_group;

4. Connect to the test_database DB.
5. Run the following SQL:

alter default privileges in schema public grant all on types to my_group;

6. Open pgAdmin III.
7. Navigate to the public schema in test_database.
8. Right-click the public schema and choose Properties.
9. Select the Default Privileges tab.
10. Note that all four subtabs are empty, and the Role drop-down lists do
not list my_group as a role.

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Sara Tan 2012-12-09 21:01:18 Helo
Previous Message Dave Page 2012-12-07 13:21:56 Re: Problem with multiple comments