Issue #3175 has been updated by Brice Figureau.
Daniel Kerwin wrote: > I recently noticed that stored configs don't make use of foreign keys. Is > there a reason to do so? > I'd like to query the database to get inventory data. You don't need foreign keys to be able to query the database. I think the reason there is no foreign key in the schema is that not every mysql storage engine support them so storedconfig installation would fail on such platform. If you really need FK, it's something you can add by yourself relatively easily, but I'm not sure adding them to the storedconfig schema is necessary (rails is doing all the relationship behind the scene). ---------------------------------------- Feature #3175: Stored configs should use foreign keys http://projects.reductivelabs.com/issues/3175 Author: Daniel Kerwin Status: Needs design decision Priority: Normal Assigned to: Brice Figureau Category: Target version: Affected version: 0.25.3 Keywords: Branch: I recently noticed that stored configs don't make use of foreign keys. Is there a reason to do so? I'd like to query the database to get inventory data. -- You have received this notification because you have either subscribed to it, or are involved in it. To change your notification preferences, please click here: http://reductivelabs.com/redmine/my/account -- You received this message because you are subscribed to the Google Groups "Puppet Bugs" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/puppet-bugs?hl=en.
