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

From: <noreply(at)pgfoundry(dot)org>
To: noreply(at)pgfoundry(dot)org
Subject: [ psqlodbc-Bugs-1002386 ] 8.02.02.00 version ODBC driver does not show error message detail (regression)
Date: 2007-03-17 05:13:15
Message-ID: 20070317051315.308372172C9@pgfoundry.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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

Browse pgsql-odbc by date

  From Date Subject
Next Message noreply 2007-03-17 11:54:09 [ psqlodbc-Bugs-1002454 ] ODBC-Driver uses false Selectstatement.
Previous Message Hiroshi Inoue 2007-03-16 23:00:14 Re: Erro on the latest version