Re: How to get error message details from libpq based psqlODBC driver (regression)

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.