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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Craig Ringer <craig(at)2ndquadrant(dot)com>
Cc: 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-30 02:50:04
Message-ID: 16087.1383101404@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Craig Ringer <craig(at)2ndquadrant(dot)com> writes:
> I'd kind of like to see FK constraints affected by RLS for
> non-superusers, at least as an option.

I think that's a complete nonstarter. Aside from the fact that such a
constraint will have no definable semantics, even the possibility that a
constraint doesn't mean what it appears to mean will prevent us from
making use of FK constraints for optimization --- something that's
pretty high on the planner to-do list.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Craig Ringer 2013-10-30 02:55:16 Re: How should row-security affects ON UPDATE RESTRICT / CASCADE ?
Previous Message Craig Ringer 2013-10-30 01:48:46 Re: How should row-security affects ON UPDATE RESTRICT / CASCADE ?