Flashnux

GNU/Linux man pages

• CentOS
• Debian
• Red Hat
• Ubuntu
• Unix

Livre :
Expressions régulières,
Syntaxe et mise en oeuvre :

ISBN : 978-2-7460-9712-4
EAN : 9782746097124
(Editions ENI)

GNU/Linux	RedHat 6.2 (Zoot)
	unlisten(l)

---

UNLISTEN

NAME
SYNOPSIS
DESCRIPTION
USAGE
COMPATIBILITY

---

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

Acknowledgement 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 session.

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

NOTES
classname needs not to 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.

A restriction in some previous releases of Postgres that a classname which does not correspond to an actual table must be enclosed in double-quotes is no longer present.

USAGE

To subscribe to an existing registration:

postgres=> LISTEN virtual;
LISTEN
postgres=> NOTIFY virtual;
NOTIFY
ASYNC NOTIFY of ’virtual’ from backend pid ’12317’ received

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

postgres=> UNLISTEN virtual;
UNLISTEN
postgres=> NOTIFY virtual;
NOTIFY
-- notice no NOTIFY event is received

COMPATIBILITY

SQL92
There is no UNLISTEN in SQL92.

---

---

unlisten(l)