[ psqlodbc-Bugs-1002386 ] 8.02.02.00 version ODBC driver does not show error message detail (regression)

Bugs item #1002386, was opened at 2007-03-02 13:41
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1002386&group_id=1000125

Category: None
Group: None
Status: Open
Resolution: None
Priority: 3
Submitted By: Andrus Moor (kobruleht)
Assigned to: Nobody (None)
Summary: 8.02.02.00 version ODBC driver does not show error message detail (regression)

Initial Comment:
To reproduce, run update statement which causes fireign key violation error  like

UPDATE mytable SET foreignkey='badvalue'


Observed:

ODBC driver returns error message without detail.


Expected:

Errorr returned from ODBC driver must contain also DETAIL: part which shows which foreign key constraint is violated
like


DETAIL: Key  (foreignkey)=(badvalue  ) is not present in table "foo".



Note.

08.01.02 version of driver returns correct error message. DETAIL: part is present in message.


Enivronment:

8.02.02.00 version ODBC Unicode driver
Microsoft Visual FoxPro 9 SP1
PostgreSQL 8.1 on Windows XP


----------------------------------------------------------------------

You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1002386&group_id=1000125