Re: Referencial integerity problem - Mailing list pgsql-bugs

From Stephan Szabo
Subject Re: Referencial integerity problem
Date
Msg-id Pine.BSF.4.21.0102121137440.77463-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Referencial integerity problem  (Mike Howard <mike@clove.com>)
List pgsql-bugs
Under 7.0 you needed update permission on the referenced table to
grab the necessary locks.  Under 7.1 you won't need this anymore.

On Thu, 8 Feb 2001, Mike Howard wrote:

> Briefly, I create two tables, one having a column which references the
> other and which implements cascade deletes and updates.  I create a user
> who has modify access on one table, but only select on the referenced
> table.  This user is not allowed to insert a record into the referencing
> table - the error message refers to the referenced table.

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Table name scope (was Re: Outer joins aren't working with views)
Next
From: Tom Lane
Date:
Subject: Re: SELECT with regular pattern '~' delivers wrong output