[DOCS] role hierarchy

2009-04-20 Thread ali haghighat
hi does postgresql support role hierarchy and how? does child inherit parent permissions?how? thanks in advance

Re: [DOCS] [GENERAL] Postgresql 8.3X supports Arrays of Composite Types?

2009-04-20 Thread Robson Fidalgo
On Mon, Apr 20, 2009 at 8:13 AM, Robson Fidalgo wrote: > Hi David, > > > > Thanks for your help, but I want a relational-object solution. The solution > presented by Tom Lane (Thanks Tom) runs very well and it is a > relational-object implementation (I suggest put a similar example in > postg

[DOCS] Does Postgresql 8.3X support Object/Class Methods and association between objects with REF?

2009-04-20 Thread Robson Fidalgo
Hello, I am study the relational-object paradigm with postgresql 8.3X and I know that it supports composite and/or array attributes. However, I didn't find documentation/examples about the usage of Object/Class Methods and association between objects with REF (like oracle does). Then, I'd like to k

Re: [DOCS] [GENERAL] Postgresql 8.3X supports Arrays of Composite Types?

2009-04-20 Thread David Fetter
On Mon, Apr 20, 2009 at 08:13:15AM -0300, Robson Fidalgo wrote: > Hi David, > > Thanks for your help, but I want a relational-object solution. You can have one without denormalizing. Just use VIEWs and rewrite RULEs for INSERTs, UPDATEs and DELETEs on them. > The solution presented by Tom Lane

Re: [DOCS] role hierarchy

2009-04-20 Thread Peter Eisentraut
On Monday 20 April 2009 10:49:20 ali haghighat wrote: > does postgresql support role hierarchy and how? > does child inherit parent permissions?how? You can configure that in some detail. All of the options you describe are supported. Start by reading the docs: http://www.postgresql.org/docs/8