Re: [PATCHES] BUG #1794: inheritance removes permissions from

Patch applied. Thanks.

---------------------------------------------------------------------------

Sean Burlington wrote:
> Michael Fuhr wrote:
> > On Thu, Jul 28, 2005 at 03:56:14PM +0100, Sean Burlington wrote:
> >
> >>Michael Fuhr wrote:
> >>
> >>>On Thu, Jul 28, 2005 at 12:48:35PM +0100, Sean Burlington wrote:
> >>>
> >>>
> >>>>Description: inheritance removes permissions from the parent table
> >>>
> >>>I think a more accurate description would be "permissions not
> >>>inherited by children," and that isn't necessarily a bug.
> >>
> >>I agree it may not be a bug - but it's more than the permissions not
> >>being inherited: the parent is affected.
> >
> >
> > Not really, once you understand what's happening. Unless you use
> > FROM ONLY, selecting from the parent selects from the parent *and*
> > its children. The parent itself isn't affected, as queries with
> > FROM ONLY should demonstrate. I understand what you're saying --
> > that there's an apparent effect on the parent -- but there really
> > isn't.
> >
> >
> >>It would be handy if this was in the documentation for anyone else who
> >>comes across this issue
> >
> >
> > Feel free to submit a documentation patch to pgsql-patches :-)
> >
>
> OK - patch attached
>
> I hope it's OK - I'm afraid I didn't spend too much time looking at the
> best way to contribute patches and just went ahead and made one ...
>
> --
>
> Sean

>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073