1 Answer
- Newest
- Most votes
- Most comments
0
With SQL Server there are 2 distinct errors for uniqueness violation, 2601 for unique index violation and 2627 for unique constraint violation. PostgreSQL don't have different error codes for unique index vs unique constraint violations, that's why, currently, in Babelfish both are mapped to SQL error 2627, as of June 30, 2022. As Babelfish is improved, correct mapping of both errors will be added. The recommended approach is to catch both errors: 2627 and 2601 so that your code will work with future versions of Babelfish.
answered 2 years ago
Relevant content
- Accepted Answerasked a year ago
- asked a year ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated 6 months ago
- AWS OFFICIALUpdated 2 years ago