Search Postgresql Archives

Notification EXTRA data

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux