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