Re: BUG #4893: Grants on inherited tables checks before constraint exclusion see, that table not needed

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Vladimir Lavrentiev" <vyorick(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4893: Grants on inherited tables checks before constraint exclusion see, that table not needed
Date: 2009-06-29 13:56:17
Message-ID: 11168.1246283777@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Vladimir Lavrentiev" <vyorick(at)gmail(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Kevin Grittner 2009-06-29 14:02:03 Re: BUG #4870: don't start service
Previous Message Craig Ringer 2009-06-29 11:19:18 Re: BUG #4892: postmaster died and didn't restart