UNLISTEN

Name

UNLISTEN  --  Stops the backend process from listening for a notification event.

Synopsis

UNLISTEN { notifyname | * }
  

Examples

notifyname

Use this parameter to specify the name of the notify condition you wish to stop listening for.

*

Passing the asterisk symbol (*) as the name of the notify condition will stop the backend from listening to any currently defined conditions.

Results

UNLISTEN

This message is displayed if the UNLISTEN command is completed successfully.

Description

Use the UNLISTEN command to unregister a current NOTIFY registration matching the notify condition specified by notifyname. Alternatively, you can use the wildcard symbol (*) to remove all listener registrations for the current session.

NoteNote
 

When a backend shuts down it will automatically issue UNLISTEN * to remove all listener registrations.

More information on using the NOTIFY and LISTEN commands (which work together to form simple IPC (interprocess communication) sysytem) can be found by referring to the NOTIFY reference section.

Examples

The following example will stop listening to the PUBLISHER_UPDATE event.

UNLISTEN PUBLISHER_UPDATE;