Re: How should row-security affects ON UPDATE RESTRICT / CASCADE ?

From: Craig Ringer <craig(at)2ndquadrant(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, Kohei KaiGai <kaigai(at)kaigai(dot)gr(dot)jp>
Subject: Re: How should row-security affects ON UPDATE RESTRICT / CASCADE ?
Date: 2013-10-29 08:53:11
Message-ID: 526F7777.4040808@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 10/29/2013 04:09 PM, Craig Ringer wrote:
> Problem is, that won't necessarily happen, because the FK check is run
> with the rights of the table owner.

Some further reading suggests that another vendor's implementation
ignores row security policy for foreign key constraint checks. So FK
constraint checks can be used to probe for data, but there are no wacky
inconsistencies with FKs.

I'm not sure I'm thrilled with that answer, but on the other hand a
better one isn't leaping out at me right now.

--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Craig Ringer 2013-10-29 08:56:30 Re: Fast insertion indexes: why no developments
Previous Message naman.iitb 2013-10-29 08:15:21 Creating partial index on a relation