[openstack-dev] [Keystone]ON DELETE RESTRICT VS ON DELETE CASCADE
Adam Young
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.
>
> —Morga
>
>>
>>
>> --
>> David
>> blog:http://www.traceback.org
>> twitter:http://twitter.com/dstanek
>> www:http://dstanek.com
>> __________________________________________________________________________
>> OpenStack Development Mailing List (not for usage questions)
>> Unsubscribe:
>> OpenStack-dev-request at lists.openstack.org?subject:unsubscribe
>> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
>
>
> __________________________________________________________________________
> OpenStack Development Mailing List (not for usage questions)
> Unsubscribe: OpenStack-dev-request at lists.openstack.org?subject:unsubscribe
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-dev/attachments/20150309/1b79d4f0/attachment.html>
More information about the OpenStack-dev
mailing list