On Mon, Jan 02, 2012 at 12:31:13PM +0100, Dimitri Fontaine wrote: > 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.
Thanks, thats interesting. Here is my current state: https://github.com/markokr/skytools/blob/master/sql/dispatch/create_partition.sql which uses info-schema for grants, which seems nicer than parsing, but still not as nice as "including all". -- marko -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers