unlisten man page on BSDi

Man page or keyword search:  
man Server   6284 pages
apropos Keyword Search (all sections)
Output format
BSDi logo
[printable version]

UNLISTEN()			 SQL Commands			    UNLISTEN()

NAME
       UNLISTEN - Stop listening for notification

SYNOPSIS
       UNLISTEN { notifyname | * }

   INPUTS
       notifyname
	      Name of previously registered notify condition.

       *      All current listen registrations for this backend are cleared.

   OUTPUTS
       UNLISTEN
	      Acknowledgment that statement has executed.

DESCRIPTION
       UNLISTEN	 is  used to remove an existing NOTIFY registration.  UNLISTEN
       cancels any existing registration of the current Postgres session as  a
       listener	 on  the  notify  condition notifyname.	 The special condition
       wildcard "*" cancels all listener registrations for  the	 current  ses‐
       sion.

       NOTIFY  [notify(l)]  contains a more extensive discussion of the use of
       LISTEN and NOTIFY.

   NOTES
       notifyname need not be a valid class name but can be any	 string	 valid
       as a name up to 32 characters long.

       The  backend  does  not complain if you UNLISTEN something you were not
       listening for.  Each backend will automatically execute UNLISTEN * when
       exiting.

USAGE
       To subscribe to an existing registration:

       LISTEN virtual;
       LISTEN
       NOTIFY virtual;
       NOTIFY
       Asynchronous NOTIFY 'virtual' from backend with pid '8448' received

       Once  UNLISTEN  has  been  executed,  further  NOTIFY  commands will be
       ignored:

       UNLISTEN virtual;
       UNLISTEN
       NOTIFY virtual;
       NOTIFY
       -- notice no NOTIFY event is received

COMPATIBILITY
   SQL92
       There is no UNLISTEN in SQL92.

SQL - Language Statements	 29 March 2001			    UNLISTEN()
[top]

List of man pages available for BSDi

Copyright (c) for man pages and the logo by the respective OS vendor.

For those who want to learn more, the polarhome community provides shell access and support.

[legal] [privacy] [GNU] [policy] [cookies] [netiquette] [sponsors] [FAQ]
Tweet
Polarhome, production since 1999.
Member of Polarhome portal.
Based on Fawad Halim's script.
....................................................................
Vote for polarhome
Free Shell Accounts :: the biggest list on the net