Re: Owner inheritance - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: Owner inheritance
Date
Msg-id 4D10D311.9020706@dunslane.net
Whole thread Raw
In response to Owner inheritance  (gsdfg gdfg <mx.morin@gmail.com>)
List pgsql-hackers

On 12/21/2010 07:04 AM, gsdfg gdfg wrote:
> Would be great if owner can be inherited from parent object (owner 
> table ==> schema owner ==> database owner).
> CREATE statement could add OWNER TO PARENT to cover this feature.
>

That syntax would violate POLA in the case of inherited tables (OWNER TO 
CONTAINER, or just OWNER TO SCHEMA etc might be clearer). And I think 
we'd have to restrict it to superusers anyway, which would seriously 
limit its usefulness.

cheers

andrew


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Owner inheritance
Next
From: tv@fuzzy.cz
Date:
Subject: Re: proposal : cross-column stats