4 ms·
If you have multiple unique constraints in the same table then it will spit back the same error code. I want to know the name of the specific constraint that wa
by VWWHFSfQ 2y ago
If you have multiple unique constraints in the same table then it will spit back the same error code. I want to know the name of the specific constraint that was violated.
Always name your indexes. Always name your constraints.
- 1a527dd5 2y agoI mean if you have that many violations that points to other problems, but sure if you are in that situation I can see how catching by name might be helpful. It's not a panacea.
- VWWHFSfQ 2y agoIt's not that hard to just name the things you care about instead of relying on auto-generated stuff from the database. PG lets you do this easily. > if you have that many violations that points to other problems No, it doesn't. This is a sophisticated design choice. You might be out of your depth here.