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

2012-01-04 Thread Robert Haas
On Fri, Dec 30, 2011 at 4:25 AM, Marko Kreen mark...@gmail.com 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

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 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

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

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

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) Have a way

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( IN priv

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

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 create GRANT