[openstack-dev] [Keystone]ON DELETE RESTRICT VS ON DELETE CASCADE
ayoung at redhat.com
Mon Mar 9 16:11:33 UTC 2015
On 03/08/2015 02:28 PM, Morgan Fainberg wrote:
> On March 8, 2015 at 11:24:37 AM, David Stanek (dstanek at dstanek.com
> <mailto:dstanek at dstanek.com>) wrote:
>> On Sun, Mar 8, 2015 at 1:37 PM, Mike Bayer<mbayer at redhat.com
>> <mailto:mbayer at redhat.com>>wrote:
>> can you elaborate on your reasoning that FK constraints should be
>> used less
>> overall? or do you just mean that the client side should be
>> mirroring the same
>> rules that would be enforced by the FKs?
>> I don't think he means that we will use them less. Our SQL backends
>> are full of them. What Keystone can't do is rely on them because not
>> all implementations of our backends support FKs.
> 100% spot on David. We support implementations that have no real
> concept of FK and we cannot assume that a cascade (or restrict) will
> occur on these implementations.
And even if the back ends do, we split behavior across identity,
assignments, and resources ,and FKs cannot cross those; Thety can and
will vary independently.
>> OpenStack Development Mailing List (not for usage questions)
>> OpenStack-dev-request at lists.openstack.org?subject:unsubscribe
> OpenStack Development Mailing List (not for usage questions)
> Unsubscribe: OpenStack-dev-request at lists.openstack.org?subject:unsubscribe
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the OpenStack-dev