public inbox for pgsql-odbc@postgresql.org  
help / color / mirror / Atom feed
From: Dave Cramer <davecramer@postgres.rocks>
To: Igor Korot <ikorot01@gmail.com>
Cc: PostgreSQL ODBC list <pgsql-odbc@postgresql.org>
Subject: Re: Catch "RAISE NOTICE" in ODBC application
Date: Sun, 30 Nov 2025 06:31:13 -0500
Message-ID: <CADK3HH+MkPAaTkZ+Ay82Ch7bdN86RB2swUoD7p2-_2q_UGk=wA@mail.gmail.com> (raw)
In-Reply-To: <CA+FnnTxse=q=47B7hbBKnJXeCy_GpyAyZ7hrAOD54nDSzYqhQA@mail.gmail.com>
References: <CA+FnnTxse=q=47B7hbBKnJXeCy_GpyAyZ7hrAOD54nDSzYqhQA@mail.gmail.com>

ChatGPT shows this:

SQLGetDiagRec(
    SQL_HANDLE_STMT,  // statement handle
    hstmt,
    iRecord,          // record number, starting at 1
    SqlState,
    &NativeError,
    MessageText,
    BufferLength,
    &TextLengthPtr
);

Notices will have:

   -

   SqlState = "00000"
   -

   NativeError = 0
   -

   MessageText = "<your NOTICE text>"

Dave Cramer
www.postgres.rocks


On Sun, 30 Nov 2025 at 02:58, Igor Korot <ikorot01@gmail.com> wrote:

> Hi, ALL,
> How do I do that?
>
> Google showed only the libpq way...
>
> Thank you.
>
>
>


reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-odbc@postgresql.org
  Cc: davecramer@postgres.rocks, ikorot01@gmail.com
  Subject: Re: Catch "RAISE NOTICE" in ODBC application
  In-Reply-To: <CADK3HH+MkPAaTkZ+Ay82Ch7bdN86RB2swUoD7p2-_2q_UGk=wA@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox