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
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 |