[ 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


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

>Comment By: Hiroshi Inoue (hinoue)
Date: 2007-03-16 00:31

Message:
Could you try the snapshot dll at
http://www.geocities.jp/inocchichichi/psqlodbc/index.html
?

regards,
Hiroshi Inoue

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

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

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match