Postgres Pro
Downloads
Home   >   mailing lists

Re: SQLExecDirectW returns SQL_SUCCESS even if sql finishes witherror - Mailing list pgsql-odbc

From Clemens Ladisch
Subject Re: SQLExecDirectW returns SQL_SUCCESS even if sql finishes witherror
Date
Msg-id e8a014cd-38d1-13f8-21f0-325fa5f3ab9e@ladisch.de
Whole thread Raw
In response to RE: SQLExecDirectW returns SQL_SUCCESS even if sql finishes witherror  ("Takahashi, Ryohei" <r.takahashi_2@jp.fujitsu.com>)
Responses RE: SQLExecDirectW returns SQL_SUCCESS even if sql finishes witherror
List pgsql-odbc
Tree view 
Takahashi, Ryohei wrote:
> Anyway, I think it is a problem that SQLExecDirectW() returns SQL_SUCCESS even if sql finishes with error.

When client_min_messages set that high, the server never reports the
error.  So the ODBC driver cannot do much about it; at best, it could
report something like "I do not know the status", but that is not
actually possible in the ODBC API.

> He wanted to reduce server logs later and set ... client_min_messages = fatal.

Setting "client_min_messages = fatal" literally means "I do not want to
know about normal errors."

This is an error in the documentation.
I've submitted a bug report: <https://www.postgresql.org/message-id/flat/15479-ef0f4cc2fd995ca2%40postgresql.org>


Regards,
Clemens

pgsql-odbc by date:

Previous
From: "Takahashi, Ryohei"
Date:
Subject: RE: SQLExecDirectW returns SQL_SUCCESS even if sql finishes witherror
Next
From: "Inoue, Hiroshi"
Date:
Subject: Re: Problem compiling in mac os with unix odbc