| Extracted from Pike v7.8 release 866 at 2018-07-18.

[Top]
Sql
Sql.pgsql

# Method Sql.pgsql()->set_notify_callback()

Method set_notify_callback

  `void set_notify_callback(string condition, void|function(int:void) notify_cb, void|int selfnotify, mixed ... args)`

Description

  With PostgreSQL you can LISTEN to NOTIFY events. This function allows you to detect and handle such events.

Parameter `condition`

  Name of the notification event we're listening to. A special case is the empty string, which matches all events, and can be used as fallback function which is called only when the specific condition is not handled. Another special case is _reconnect which gets called whenever the connection unexpectedly drops and reconnects to the database.

Parameter `notify_cb`

  Function to be called on receiving a notification-event of condition condition . The callback function is invoked with `void notify_cb(pid,condition,extrainfo, .. args);` pid is the process id of the database session that originated the event. condition contains the current condition. extrainfo contains optional extra information specified by the database. The rest of the arguments to notify_cb are passed verbatim from args . The callback function must return no value.

Parameter `selfnotify`

  Normally notify events generated by your own session are ignored. If you want to receive those as well, set selfnotify to one.

Parameter `args`

  Extra arguments to pass to notify_cb .

Note

  This function is PostgreSQL-specific, and thus it is not available through the generic SQL-interface.