Re: ODBC - Retrieving info messages - RAISE NOTICE

Wolfgang Apolinarski wrote:
> only the last message ("3") is retrieved, when a statement like
> DO $$
> RAISE NOTICE '1';
> RAISE NOTICE '2';
> RAISE NOTICE '3';
> END$$;
> is executed.

When receiving a notice from libpq, the driver calls QR_set_notice(),
which replaces any previous notice.  To get all notices separated with
a semicolon, try using QR_add_notice() instead (see the patch below).

> Maybe this is a general constraint when using ODBC

In theory, the ODBC API (SQLGetDiagRec) would allow any number of
messages.


Regards,
Clemens


--- psqlodbc.orig/connection.c
+++ psqlodbc/connection.c
@@ -894,7 +894,7 @@ handle_pgres_error(ConnectionClass *self
         {
             if (QR_command_successful(res))
                 QR_set_rstatus(res, PORES_NONFATAL_ERROR); /* notice or warning */
-            QR_set_notice(res, errmsg);  /* will dup this string */
+            QR_add_notice(res, errmsg);  /* will dup this string */
         }
         goto cleanup;
     }