Marko Kreen <markokr@gmail.com> writes:
> I tried to generalize a function that creates partitions
> for a table and found out it's impossible to do it for grants.
>
> Basically, what I want is a child table that takes it's grants
> from parent table. IMHO quite reasonable request. But I don't
> see a way to do it in pl/pgsql. (Writing parser in plpgsql
> for aclitemout() output does not count.)
We solved that manually in https://github.com/slardiere/PartMgr, maybe
you will find it useful for pre-9.2 releases. See function
partition.grant() and partition.setgrant() in part_api.sql.
Regards,
--
Dimitri Fontaine
http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support