Babelfish returns 2601 - Cannot insert duplicate key row in object '%.*ls' with unique index '%.*ls'.

0

I'm receiving this error when I should get a 2627 for unique constraints violation. Please help.

AWS
light
asked 2 years ago246 views
1 Answer
0
Accepted Answer

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.

AWS
light
answered 2 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions