Notification EXTRA data

From: "news(dot)postgresql(dot)org" <rdn(at)cc(dot)lv>
To: pgsql-general(at)postgresql(dot)org
Subject: Notification EXTRA data
Date: 2006-04-20 09:39:03
Message-ID: e27krp$19q9$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

sql-notify.html :

Higher-level mechanisms can be built by using tables in the database
to pass additional data (beyond a mere notification name) from notifier
to listener(s).

How ?

root2=> select * from pg_listener ;
relname | listenerpid | notification
---------+-------------+--------------
aaa | 723 | 0
(1 row)

grep -5 "typedef struct pgNotify" /usr/local/include/libpq-fe.h

typedef struct pgNotify
{
char *relname; /* notification condition name */
int be_pid; /* process ID of server process
*/
char *extra; /* notification parameter */
} PGnotify;

I need to insert "extra" data - uid, ...

PGnotify *notify;
notify->extra;

........
Thanks

Browse pgsql-general by date

  From Date Subject
Next Message Alban Hertroys 2006-04-20 09:43:22 Re: Categories and Sub Categories (Nested)
Previous Message Shane Ambler 2006-04-20 09:32:26 Re: Unable to connect to PostgreSQL server