Re: Possible bug with permissions. (Table A has select , insert, update rights but has a reference to a second table that only has select rights)

It's been discussed a fair bit in the mailing lists but I don't think it's
made the documentation.  The triggers use SELECT FOR UPDATE to get the row
locks but that forces the update permission need.  In 7.1 this should be
gone (Peter E had a patch to remove the most common cases of this).

Stephan Szabo
sszabo@bigpanda.com

On Fri, 6 Oct 2000, Wendel Leibe wrote:

> I think I have found a bug with Postgres' permissions.  I have combed
> through the documentation, but I haven't been able to find an explanation
> for the following problem.
> 
> First of all here is what I am running.
> Postgress version 7.0.2 ,
> OS  Linux Red Hat 6.2
> Kernel version 2.2.17
>