Unix/Linux Go Back    


RedHat 9 (Linux i386) - man page for unlisten (redhat section 7)

Linux & Unix Commands - Search Man Pages
Man Page or Keyword Search:   man
Select Man Page Set:       apropos Keyword Search (sections above)


UNLISTEN(7)				   SQL Commands 			      UNLISTEN(7)

NAME
       UNLISTEN - stop listening for a 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 PostgreSQL session as a listener on the notify condition noti-
       fyname.	 The special condition wildcard * cancels all listener registrations for the cur-
       rent session.

       NOTIFY [notify(7)] 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  64
       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		    2002-11-22				      UNLISTEN(7)
Unix & Linux Commands & Man Pages : ©2000 - 2018 Unix and Linux Forums


All times are GMT -4. The time now is 04:59 AM.