Re: PATCH: Integrity constraint violation should set SQLSTATE to 23000

> -----Original Message-----
> From: Chris Ingram [mailto:cingram@intellisync.com]
> Sent: 03 October 2005 23:04
> To: Dave Page
> Cc: pgsql-odbc@postgresql.org
> Subject: RE: [ODBC] PATCH: Integrity constraint violation
> should set SQLSTATE to 23000
>
> Thanks for pointing out a much better way to address the
> problem, Dave.
>
> I've attached a patch that uses the SQLSTATE from the backend any time
> the error condition after executing a query is
> STMT_ERROR_TAKEN_FROM_BACKEND.  Besides solving the problem I
> reported,
> this seems to make much more sense than setting the SQLSTATE
> arbitrarily
> to HY000 "General Error" in this situation.  I look forward to your
> feedback.

Thanks Chris - patch applied.

Regards, Dave.