Home Man
Search
Today's Posts
Register

Linux & Unix Commands - Search Man Pages

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

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)


All times are GMT -4. The time now is 11:25 PM.

Unix & Linux Forums Content Copyrightę1993-2018. All Rights Reserved.
UNIX.COM Login
Username:
Password:  
Show Password