NOTIFY/LISTEN with ODBC interface

Started by Igor Korotover 7 years ago3 messagesgeneral
Jump to latest
#1Igor Korot
ikorot01@gmail.com

Hi,
Is there a way to write a code found at
https://www.postgresql.org/docs/9.1/libpq-example.html
Example 2 with the ODBC interface?

Thank you.

#2Clemens Ladisch
clemens@ladisch.de
In reply to: Igor Korot (#1)
Re: NOTIFY/LISTEN with ODBC interface

Igor Korot wrote:

Is there a way to write [LISTEN/NOTIFY] with the ODBC interface?

At the moment, no.

ODBC is a standard interface, so there are no functions for this defined.

It might be possible to add PG-specific extensions to the ODBC driver,
but this has not (yet) be done.

Regards,
Clemens

#3Igor Korot
ikorot01@gmail.com
In reply to: Clemens Ladisch (#2)
Re: NOTIFY/LISTEN with ODBC interface

Hi, Clemens, et al,

On Tue, Dec 25, 2018 at 12:23 AM Clemens Ladisch <clemens@ladisch.de> wrote:

Igor Korot wrote:

Is there a way to write [LISTEN/NOTIFY] with the ODBC interface?

At the moment, no.

ODBC is a standard interface, so there are no functions for this defined.

It might be possible to add PG-specific extensions to the ODBC driver,
but this has not (yet) be done.

Thank you for the reply.
I guess I will just have to implement minimal schema watching algorithm.

Show quoted text

Regards,
Clemens