Re: pgAdmin III does not display Default Privileges for schemas

Okay, you're right. Sorry about that -- that exact test case is working,
however, other default privileges I've modified aren't showing up. The
common denominator seems to be whether the role is a group role or a login
role. Default privilege changes for login roles don't seem to show up in
pgAdmin III -- are they supposed to?

Shira

On Thu, Feb 13, 2014 at 12:54 PM, Guillaume Lelarge
<guillaume(at)lelarge(dot)info>wrote:

> On Thu, 2014-02-13 at 12:40 -0800, Shira Bezalel wrote:
> > Hello,
> >
> > I found this thread from 2012 concerning a problem where pgAdmin III
> > doesn't display default privileges for schemas:
> >
> >
> http://www.postgresql.org/message-id/1356354218.2000.30.camel@localhost.localdomain
> >
> > The thread says the fix has been made, but I just downloaded the latest
> > Windows version (v 1.18.1) of pgAdmin III and the problem still seems to
> be
> > happening. Is the fix not available in this version?
> >
>
> It should.
>
> > 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
> >
> > Thank you,
> > Shira
>
>
> --
> Guillaume
> http://blog.guillaume.lelarge.info
> http://www.dalibo.com
>
>

--
Shira Bezalel
Systems & Database Manager
San Francisco Estuary Institute
www.sfei.org
Ph: 510-746-7304