Re: [HACKERS] [RFC] grants vs. inherited tables

2012-01-04 Thread Robert Haas
On Fri, Dec 30, 2011 at 4:25 AM, Marko Kreen wrote: >> 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'

Re: [HACKERS] [RFC] grants vs. inherited tables

2012-01-03 Thread Marko Kreen
On Mon, Jan 02, 2012 at 12:31:13PM +0100, Dimitri Fontaine wrote: > Marko Kreen 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 pa

Re: [HACKERS] [RFC] grants vs. inherited tables

2012-01-02 Thread Dimitri Fontaine
Marko Kreen 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

Re: [HACKERS] [RFC] grants vs. inherited tables

2011-12-30 Thread Marko Kreen
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

Re: [HACKERS] [RFC] grants vs. inherited tables

2011-12-29 Thread Alvaro Herrera
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 crea

Re: [HACKERS] [RFC] grants vs. inherited tables

2011-12-29 Thread Marko Kreen
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( > >

Re: [HACKERS] [RFC] grants vs. inherited tables

2011-12-29 Thread Alvaro Herrera
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[], >

[HACKERS] [RFC] grants vs. inherited tables

2011-12-29 Thread Marko Kreen
Hello, 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 p