Re: [RFC] grants vs. inherited tables

On Thu, Dec 29, 2011 at 11:11:22PM -0300, Alvaro Herrera wrote:
> 
> Excerpts from Marko Kreen's message of jue dic 29 15:22:49 -0300 2011:
> > 
> > On Thu, Dec 29, 2011 at 03:12:50PM -0300, Alvaro Herrera wrote:
> > > Excerpts from Marko Kreen's message of jue dic 29 15:04:49 -0300 2011:
> > > > 3) Have a way to format aclitem into something
> > > >    that can used to create GRANT statement easily.  Eg:
> > > > 
> > > >      pg_get_privilege_info(
> > > >           IN priv aclitem,
> > > >       OUT rolename text,
> > > >       OUT privlist text[],
> > > >       OUT privlist_with_grant_option text[]);
> > > > 
> > > >    This allows doing complex introspection in pl/pgsql
> > > >    and also helps tools that want to re-create table structure
> > > >    in other databases.
> > > 
> > > aclexplode?
> > 
> > I guess that decides the name.  :)
> 
> I have the (hopefully wrong) impression that you're missing the fact
> that it already exists, at least in 9.0.

You are right, I missed it.  For quite obvious reason:
 $ grep -ri aclexplode doc/ $

Is there a good reason why it's undocumented?  Internal/unstable API?
I better avoid it then.  But I would like to have this or similar
function as part of public API.

Although this hints also to an obvious area that I shouldn't
have missed - the grants can be seen from information_schema...

I guess the 3) is covered then.

-- 
marko