UNLISTEN(7) PostgreSQL 9.2.7 Documentation UNLISTEN(7)NAME
UNLISTEN - stop listening for a notification
SYNOPSIS
UNLISTEN { channel | * }
DESCRIPTION
UNLISTEN is used to remove an existing registration for NOTIFY events. UNLISTEN cancels any existing registration of the current
PostgreSQL session as a listener on the notification channel named channel. The special wildcard * cancels all listener registrations for
the current session.
NOTIFY(7) contains a more extensive discussion of the use of LISTEN and NOTIFY.
PARAMETERS
channel
Name of a notification channel (any identifier).
*
All current listen registrations for this session are cleared.
NOTES
You can unlisten something you were not listening for; no warning or error will appear.
At the end of each session, UNLISTEN * is automatically executed.
A transaction that has executed UNLISTEN cannot be prepared for two-phase commit.
EXAMPLES
To make a registration:
LISTEN virtual;
NOTIFY virtual;
Asynchronous notification "virtual" received from server process with PID 8448.
Once UNLISTEN has been executed, further NOTIFY messages will be ignored:
UNLISTEN virtual;
NOTIFY virtual;
-- no NOTIFY event is received
COMPATIBILITY
There is no UNLISTEN command in the SQL standard.
SEE ALSO LISTEN(7), NOTIFY(7)PostgreSQL 9.2.7 2014-02-17 UNLISTEN(7)
Check Out this Related Man Page
UNLISTEN(7) SQL Commands UNLISTEN(7)NAME
UNLISTEN - stop listening for a notification
SYNOPSIS
UNLISTEN { name | * }
DESCRIPTION
UNLISTEN is used to remove an existing registration for NOTIFY events. UNLISTEN cancels any existing registration of the current Post-
greSQL session as a listener on the notification name. The special wildcard * cancels all listener registrations for the current session.
NOTIFY [notify(7)] contains a more extensive discussion of the use of LISTEN and NOTIFY.
PARAMETERS
name Name of a notification (any identifier).
* All current listen registrations for this session are cleared.
NOTES
You can unlisten something you were not listening for; no warning or error will appear.
At the end of each session, UNLISTEN * is automatically executed.
EXAMPLES
To make a registration:
LISTEN virtual;
NOTIFY virtual;
Asynchronous notification "virtual" received from server process with PID 8448.
Once UNLISTEN has been executed, further NOTIFY commands will be ignored:
UNLISTEN virtual;
NOTIFY virtual;
-- no NOTIFY event is received
COMPATIBILITY
There is no UNLISTEN command in the SQL standard.
SEE ALSO
LISTEN [listen(7)], NOTIFY [notify(7)]
SQL - Language Statements 2010-05-14 UNLISTEN(7)
Man Page
8 More Discussions You Might Find Interesting
1. Post Here to Contact Site Administrators and Moderators
This is has been posted many times before... It is not in this forum as of now, so I have decided to put it here :D
I'm listening to The Outsiders (AKA Hell is for Heros Part I) by Modern Life is War.... what about ya'll? (4 Replies)
Hi,
I am using the NOTIFY command and I am getting the emails.. I tried MAILX and e-mail is being sent. I want to use NOTIFY to see if my jobs are completed or not. Am I missing something..
All your ideas are greatly appreciated..
Thanks
Venky (2 Replies)
Discussion started by: venkyA
2 Replies
4. Forum Support Area for Unregistered Users & Account Problems
I tried registering couple of times, and got the following message.
Sorry, registration denied. We check new registrations against a database of known forum spammers. At this time, we are unable to contact this database to verify your registration. We are sorry for the inconvenience but please... (0 Replies)
Discussion started by: josvasanth
0 Replies
5. Forum Support Area for Unregistered Users & Account Problems
I tried registering couple of times, and got the following message.
"Sorry, registration denied. We check new registrations against a database of known forum spammers. At this time, we are unable to contact this database to verify your registration. ...you might want to try searching the... (1 Reply)
Hi,
I got a notification today carrying the below message:
Dear Manish00712,
You have received a reminder from The UNIX and Linux Forums.
Reason:
-------
Technical Question in Non-Technical Forum.
I had posted one question in Solaris Forum. I do not understand on why did i get this... (1 Reply)