ODBC - Retrieving info messages - RAISE NOTICE

From: "Wolfgang Apolinarski" <wolfgang(dot)apolinarski(at)googlemail(dot)com>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: ODBC - Retrieving info messages - RAISE NOTICE
Date: 2018-02-01 16:45:30
Message-ID: 005501d39b7c$12bf4010$383dc030$@googlemail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi,

When executing a PL/pgsql query using powershell with ODBC (yes, a somehow special setup), it is possible to register to the event "InfoMessage" (with Register-ObjectEvent) to retrieve all messages that are created for example by using "RAISE NOTICE".
While this works fine when using MS SQL and the SqlConnection (all print statements are retrieved), it does not work with Postgres and the OdbcConnection, here, only the last message ("3") is retrieved, when a statement like
DO $$
RAISE NOTICE '1';
RAISE NOTICE '2';
RAISE NOTICE '3';
END$$;
is executed.

Maybe this is a general constraint when using ODBC, but maybe I am doing something terribly wrong (other than using powershell with Postgresql).

Best regards,
Wolfgang

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Mario De Frutos 2018-02-09 17:02:33 Patch for an encoding bug in the derive_locale_encoding function
Previous Message Richard Hetherington 2018-01-26 14:13:23 RE: statement timeout with psqlODBC 09.05.300+