[katello-devel] The importance of foreign keys

[Martin Bacovsky]

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...

Martin