Re: Catch "RAISE NOTICE" in ODBC application
| От | Igor Korot |
|---|---|
| Тема | Re: Catch "RAISE NOTICE" in ODBC application |
| Дата | |
| Msg-id | CA+FnnTzpGzMLMMH1HU_cF5y=MmydwVSuffmfhvDsAdqK9WAQcA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Catch "RAISE NOTICE" in ODBC application (Igor Korot <ikorot01@gmail.com>) |
| Ответы |
Re: Catch "RAISE NOTICE" in ODBC application
|
| Список | pgsql-odbc |
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 doDave Cramerwww.postgres.rocksOn 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 Cramerwww.postgres.rocksOn 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 по дате отправления: