[ 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

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

>Comment By: Hiroshi Inoue (hinoue)
Date: 2007-03-17 05:13

Message:
> Can you add some delimiter (0x0D or space) between
message and detail?

OK please try the snapshot dll again.

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

Comment By: Andrus Moor (kobruleht)
Date: 2007-03-16 19:40

Message:
This issue is solved in snapshot, thank you.

Can you add some delimiter (0x0D or space) between message
and detail?
Currently they are cancatenated together.

When this will be official driver ?

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

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