Skip site navigation (1) Skip section navigation (2)

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

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Sean Burlington <sean(at)uncertainty(dot)org(dot)uk>
Cc: Michael Fuhr <mike(at)fuhr(dot)org>, pgsql-bugs(at)postgresql(dot)org,pgsql-patches(at)postgresql(dot)org
Subject: Re: [PATCHES] BUG #1794: inheritance removes permissions from
Date: 2005-08-13 01:55:44
Message-ID: 200508130155.j7D1til20853@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-patches
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

In response to

pgsql-bugs by date

Next:From: Bruce MomjianDate: 2005-08-13 02:07:10
Subject: Re: Server broken down in covering GB18030
Previous:From: Bruce MomjianDate: 2005-08-12 21:02:34
Subject: Re: BUG #1766: contrib/ modules can't install with --without-docdir

pgsql-patches by date

Next:From: Bruce MomjianDate: 2005-08-13 02:06:21
Subject: Re: [patch 0/7] more patches for pgcrypto
Previous:From: Bruce MomjianDate: 2005-08-13 01:53:25
Subject: Re: PL/pgSQL: SELECT INTO EXACT

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group