signals in ODBC? - Mailing list pgsql-interfaces

From Kovacs Zoltan Sandor
Subject signals in ODBC?
Date
Msg-id Pine.LNX.4.05.10010251411460.30412-100000@pc10.radnoti-szeged.sulinet.hu
Whole thread Raw
List pgsql-interfaces
My goal is for a connection to receive signals from other connections.
E.g., I would get the information about changing a row of a table by
an other connection. This would be great having the information at once.
An ugly and slow solution is to send queries to the server e.g. twice
a minute or so---but is there a better way?

Browsing the documentation I found NOTIFY and LISTEN. Can I use them
within an ODBC connection? Is it possible to catch a NOTIFY signal this way?

As I realized, the NOTIFY statement doesn't have a second parameter,
i.e. I cannot give any other signal to an other connection than
"Yes" or "No". What about future plans?

Regards, Zoltan



pgsql-interfaces by date:

Previous
From: stuart hodgkinson
Date:
Subject: ODBC info & help!
Next
From: Thomas Lockhart
Date:
Subject: Re: signals in ODBC?