Re: How to get error message details from libpq based psqlODBC driver(regression) - Mailing list pgsql-general

From Ron
Subject Re: How to get error message details from libpq based psqlODBC driver(regression)
Date
Msg-id d4ce4a5c-3d88-6168-5dbb-2d4b7e104fb0@gmail.com
Whole thread Raw
In response to Re: How to get error message details from libpq based psqlODBC driver(regression)  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
On 2/22/20 5:19 PM, Adrian Klaver wrote:
> On 2/22/20 2:37 PM, Andrus wrote:
>> Hi!
>>
>> I'm looking for a way to fix psqlODBC driver regression.
>>
>> Starting at psqlODBC 09.05.0100 when psqlODBC driver uses libpq for all
>> operations (earlier versions used libpg only for authentication) ODBC client
>> does not show error message details.
>>
>> For example, users got only generic error message like
>>
>>     Connectivity error: ERROR: insert or update on table "mytable" violates
>>     foreign key constraint  "mytable_myfield_fkey
>>
>> Error message details like
>>
>>     Key (myfield)=(mykeyvalue) is not present in table "mymastertable".;
>>
>> are no more returned.
>>
>> How to detailed error message or at least only bad key value "mykeyvalue"
>> which is returned in error message details ?
>>
[snip]
>
> What does the log_error_verbosity setting in postgresql.conf show?

Does that affect what the ODBC driver sends back to the user?

-- 
Angular momentum makes the world go 'round.



pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: How to get error message details from libpq based psqlODBC driver(regression)
Next
From: Ron
Date:
Subject: Re: How to fix 0xC0000005 exception in Postgres 9.0