Request a Demo
Home   >   mailing lists

Re: Catch "RAISE NOTICE" in ODBC application - Mailing list pgsql-odbc

From Igor Korot
Subject Re: Catch "RAISE NOTICE" in ODBC application
Date
Msg-id CA+FnnTzpGzMLMMH1HU_cF5y=MmydwVSuffmfhvDsAdqK9WAQcA@mail.gmail.com
Whole thread Raw
In response to Catch "RAISE NOTICE" in ODBC application  (Igor Korot <ikorot01@gmail.com>)
Responses Re: Catch "RAISE NOTICE" in ODBC application
List pgsql-odbc
Tree view
Hi, Dave,

Let’s say I catch CREATE TABLE DDL command and I ran create table inside my program.

It will be caught and I can process it with that call.

Now what would happen if I run CREATE TABLE inside psql shell?

It will raise the notice but will I be able to catch it?

Thank you.


On Sun, Nov 30, 2025 at 12:10 PM Dave Cramer <davecramer@postgres.rocks> wrote:
I have no idea what psql will do
Dave Cramer
www.postgres.rocks


On Sun, 30 Nov 2025 at 12:37, Igor Korot <ikorot01@gmail.com> wrote:
Hi,

Will it catch it if the event occur inside the application only or from psql as well?

Thank you.


On Sun, Nov 30, 2025 at 3:31 AM Dave Cramer <davecramer@postgres.rocks> wrote:
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.


pgsql-odbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: Catch "RAISE NOTICE" in ODBC application
Next
From: Dave Cramer
Date:
Subject: Re: Catch "RAISE NOTICE" in ODBC application