[katello-devel] The importance of foreign keys

[Mike McCune]

On 03/13/2013 08:28 AM, Martin Bacovsky wrote:
> On 03/13/2013 02:18 PM, Ivan Necas wrote:
>> Hey,
>>
>> I know this topic appeared here several times but still it doesn't seem
>> to be considered important. Here is an issue that I've hit today [1]: see
>> it's description for more details.
>>
>> This kind of issues is really dangerous because there is generally a time
>> span between the error that uses sees and the moment when the cause happens.
>> (in this case promoting a changeset vs. deleting an environment). We already
>> hit this kind of issues in the past and it's not fun debugging it, especially
>> on the customer side.
>>
>> Therefore, I would like to open this topic again and ask for reconsideration
>> of the priority and ideally make introducing of foreign keys for associations
>> in our db one of the high-priority tasks for next sprint.
>>
>> [1] - https://github.com/Katello/katello/pull/1743
>>
>> -- Ivan
>>
>> _______________________________________________
>> katello-devel mailing list
>> katello-devel at redhat.com
>> https://www.redhat.com/mailman/listinfo/katello-devel
> +1 for letting postgres do its job. Aeolus team did the same a few weeks
> ago, so we can ask there for tips and inspiration...
>


huge +1  no brainer

Mike