Re: DEFAULT PRIVILEGES incorrect

Hi Dave,

Sure I will look into it and get back.

Regards,
Sanket Mehta
Sr Software engineer
Enterprisedb

On Wed, Feb 10, 2016 at 3:03 PM, Dave Page <dpage(at)pgadmin(dot)org> wrote:

> Sanket - can you take a look at this when you get a minute please?
>
> Thanks.
>
> On Wed, Feb 10, 2016 at 4:23 AM, Erwin Brandstetter <brsaweda(at)gmail(dot)com>
> wrote:
> > This bug has not been addressed in pgAdmin 1.22.0, yet.
> >
> > If I run this as user postgres:
> >
> > ALTER DEFAULT PRIVILEGES FOR ROLE foo IN SCHEMA test
> > GRANT SELECT ON TABLES
> > TO bar;
> >
> > Then the SQL pane says (still as user postgres):
> >
> > ALTER DEFAULT PRIVILEGES IN SCHEMA test
> > GRANT SELECT ON TABLES
> > TO bar;
> >
> > Which is incorrect and misleading.
> >
> > Regards
> >
> > Erwin
> >
> > On Thu, Aug 13, 2015 at 2:45 PM, Erwin Brandstetter <brsaweda(at)gmail(dot)com>
> > wrote:
> >>
> >> The display of ALTER DEFAULT PRIVILEGES statements can be incorrect.
> >>
> >> I reported this bug in 2013, but it seems like it never got through:
> >> http://www.postgresql.org/message-id/528C2D00.6010905@falter.at
> >>
> >> Details, with steps to reproduce:
> >> https://redmine.postgresql.org/issues/694
> >>
> >> Just tested with version 1.20 again and the situation seems unchanged.
> >>
> >> Regards
> >> Erwin
> >
> >
>
>
>
> --
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>