3 ms·

> If one wants to use the natural key Yeah, that's why you shouldn't use natural keys as primary ones.

• magicalhippo 2y ago
  Learned that lesson a bit too late for that. But yea, these days I never use natural keys.
  • marcosdumay 2y ago
    I really hate that the educational literature says it's an option. Yet everybody knows it's something you should never do, no exceptions.
    • mycall 2y ago
      Maintaining old databases is one reason to use natural keys. There are a lot of them in the wild.
      • marcosdumay 2y ago
        It's not a valid reason for adding more of them. It's only a reason to be stuck inheriting some.