From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
---|---|
To: | Nathan Alden <me(at)nathanalden(dot)com> |
Cc: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: pgAdmin III does not display Default Privileges for schemas |
Date: | 2012-12-24 13:03:38 |
Message-ID: | 1356354218.2000.30.camel@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
On Fri, 2012-12-07 at 20:38 -0600, Nathan Alden wrote:
> 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.
Thanks for your report, it's fixed now.
--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Lelarge | 2012-12-24 13:48:55 | Re: See full query text in Server Status window |
Previous Message | Guillaume Lelarge | 2012-12-24 10:43:13 | Re: super slow query editor when in NX session |