Re: How to fix psqlODBC driver regression to get error message details

From: Clemens Ladisch <clemens(at)ladisch(dot)de>
To: pgsql-odbc(at)lists(dot)postgresql(dot)org
Subject: Re: How to fix psqlODBC driver regression to get error message details
Date: 2020-02-24 08:22:20
Message-ID: caad6457-67d1-314b-2642-ad343aa8069f@ladisch.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Andrus wrote:
> Error message details like
>
> Key (myfield)=(mykeyvalue) is not present in table "mymastertable".;
>
> are no more returned.

The problem is that psqlODBC does not call the libpq APIs that would
return this information; connection.c says:

/*
* The full message with details and context and everything could
* be obtained with PQresultErrorMessage(). I think that would be
* more user-friendly, but for now, construct a message with
* severity and primary message, which is backwards compatible.
*/

There should be connection settings for the error verbosity and context
visibility.

Regards,
Clemens

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Inoue, Hiroshi 2020-02-27 02:43:54 Re: How to fix psqlODBC driver regression to get error message details
Previous Message Clemens Ladisch 2020-02-23 17:13:59 Re: Error on install ODBC driver