Re: BUG #4893: Grants on inherited tables checks before constraint exclusion see, that table not needed - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #4893: Grants on inherited tables checks before constraint exclusion see, that table not needed
Date
Msg-id 11168.1246283777@sss.pgh.pa.us
Whole thread Raw
In response to BUG #4893: Grants on inherited tables checks before constraint exclusion see, that table not needed  ("Vladimir Lavrentiev" <vyorick@gmail.com>)
List pgsql-bugs
"Vladimir Lavrentiev" <vyorick@gmail.com> writes:
> Description:        Grants on inherited tables checks before constraint
> exclusion see, that table not needed

This is not a bug.  Sorry, but that's just the way it works: you need
suitable permission on every table referenced by the query.  Constraint
exclusion is just an optimization, it does not change the semantics;
in particular it doesn't change permissions requirements.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Craig Ringer
Date:
Subject: Re: BUG #4892: postmaster died and didn't restart
Next
From: "Kevin Grittner"
Date:
Subject: Re: BUG #4870: don't start service