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 -- Sent via pgsql-hackers mailing list (firstname.lastname@example.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers