Thread: Error codes returned by SQLGetDiagRec

Error codes returned by SQLGetDiagRec

From
Abhishek Kumar
Date:
Hi,

The native error code returned by SQLGetDiagRec seems to be very generic. Example : It returns the value 1 in case of "duplicate key error". 
Do we have an exhaustive list of native error code with the corresponding error for PostgreSQL ODBC driver ? ( i am assuming a one to one mapping of error code to an error

Please advise me on the same. I need to do some handling depending on the error code i get.

Regards,
Abhishek Kumar

Re: Error codes returned by SQLGetDiagRec

From
Dave Cramer
Date:
Hi Abhishek,

Can you please file this issue on github https://github.com/postgresql-interfaces/psqlodbc/issues

Dave Cramer
www.postgres.rocks


On Fri, 27 Sept 2024 at 11:32, Abhishek Kumar <abhishek.aak0@gmail.com> wrote:
Hi,

The native error code returned by SQLGetDiagRec seems to be very generic. Example : It returns the value 1 in case of "duplicate key error". 
Do we have an exhaustive list of native error code with the corresponding error for PostgreSQL ODBC driver ? ( i am assuming a one to one mapping of error code to an error

Please advise me on the same. I need to do some handling depending on the error code i get.

Regards,
Abhishek Kumar