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: 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