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

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend