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