10 More Discussions You Might Find Interesting
1. What is on Your Mind?
Which post should win this weeks UNIX/Linux post of the week nomination contest?
Choose from the posts listed throughout the forum(s), and vote for your favorite post now.
What is Topic Of The Week?
Post of the Week is a contest that select posts which we would like the community to... (0 Replies)
Discussion started by: Linux Bot
0 Replies
2. What is on Your Mind?
Which post should win this weeks UNIX/Linux post of the week nomination contest?
Choose from the posts listed throughout the forum(s), and vote for your favorite post now.
What is Topic Of The Week?
Post of the Week is a contest that select posts which we would like the community to... (1 Reply)
Discussion started by: Linux Bot
1 Replies
3. What is on Your Mind?
Which post should win this weeks UNIX/Linux post of the week nomination contest?
Choose from the posts listed throughout the forum(s), and vote for your favorite post now.
What is Topic Of The Week?
Post of the Week is a contest that select posts which we would like the community to... (0 Replies)
Discussion started by: Linux Bot
0 Replies
4. What is on Your Mind?
Which post should win this weeks UNIX/Linux post of the week nomination contest?
Choose from the posts listed throughout the forum(s), and vote for your favorite post now.
What is Topic Of The Week?
Post of the Week is a contest that select posts which we would like the community to... (0 Replies)
Discussion started by: Linux Bot
0 Replies
5. What is on Your Mind?
Which post should win this weeks UNIX/Linux post of the week nomination contest?
Choose from the posts listed throughout the forum(s), and vote for your favorite post now.
What is Topic Of The Week?
Post of the Week is a contest that select posts which we would like the community to... (0 Replies)
Discussion started by: Linux Bot
0 Replies
6. What is on Your Mind?
Which post should win this weeks UNIX/Linux post of the week nomination contest?
Choose from the posts listed throughout the forum(s), and vote for your favorite post now.
What is Topic Of The Week?
Post of the Week is a contest that select posts which we would like the community to... (8 Replies)
Discussion started by: Linux Bot
8 Replies
7. Forum Support Area for Unregistered Users & Account Problems
How to post a new thread (Regarding Unix related doubts) in Unix Forums.
I registered my id but I am unable to post my Questions to Forum.
Thanks & Regards,
indusri (1 Reply)
Discussion started by: indusri
1 Replies
8. Advertise with Us
The UNIX and Linux Job Board is a service provided by the The UNIX and Linux Forums to help employers connect with UNIX and Linux professionals. All proceeds from this service go towards supporting the forums. Please PM Neo or email with any questions about this service.
Promotion A: $99 ... (0 Replies)
Discussion started by: Neo
0 Replies
9. Post Here to Contact Site Administrators and Moderators
The UNIX and Linux Job Board is a service provided by the The UNIX and Linux Forums to help employers connect with UNIX and Linux professionals. All proceeds from this service go towards supporting the forums. Please PM Neo or email with any questions about this service.
Promotion A: $99 ... (0 Replies)
Discussion started by: Neo
0 Replies
10. Advertise with Us
The UNIX and Linux Job Board is a service provided by the The UNIX and Linux Forums to help employers connect with UNIX and Linux professionals. All proceeds from this service go towards supporting the forums. Please PM Neo or email with any questions about this service.
Promotion A: $99 ... (0 Replies)
Discussion started by: Neo
0 Replies
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 notifyname. The special condition wildcard * cancels all listener registrations for the current ses-
sion.
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)