Re: [PATCHES] BUG #1794: inheritance removes permissions from - Mailing list pgsql-bugs

From Bruce Momjian
Subject Re: [PATCHES] BUG #1794: inheritance removes permissions from
Date
Msg-id 200508130155.j7D1til20853@candle.pha.pa.us
Whole thread Raw
In response to Re: BUG #1794: inheritance removes permissions from the parent  (Sean Burlington <sean@uncertainty.org.uk>)
List pgsql-bugs
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@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-bugs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: BUG #1766: contrib/ modules can't install with --without-docdir
Next
From: Bruce Momjian
Date:
Subject: Re: Server broken down in covering GB18030