unlisten.hlp
上传用户:blenddy
上传日期:2007-01-07
资源大小:6495k
文件大小:1k
- .pgaw:Help.f.t insert end "UNLISTEN" {bold} " 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" {link notify} " contains a more extensive discussion of the use of LISTEN and NOTIFY.
- " {} "Synopsis" {bold} "
- " {} "
- UNLISTEN { notifyname | * }
- " {code} "Usage" {bold} "
- " {} "
- postgres=> LISTEN virtual;
- LISTEN
- postgres=> NOTIFY virtual;
- NOTIFY
- ASYNC NOTIFY of 'virtual' from backend pid '12317' received
- postgres=> UNLISTEN virtual;
- UNLISTEN
- postgres=> NOTIFY virtual;
- NOTIFY
- -- notice no NOTIFY event is received
- postgres=>
- " {code} "Notes" {bold} "
- 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.
- "