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

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=10023 86&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=10023 86&group_id=1000125

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq