UNLISTEN 中文man页面

系统
UNLISTEN 用于删除一个现有的已注册的 NOTIFY 事件。 UNLISTEN 取消当前 PostgreSQL 会话中的所有对通知条件 notifyname 监听。 特殊的条件通配符 * 则取消对当前会话的所有通知条件的监听。

NAME

UNLISTEN - 停止监听通知信息

SYNOPSIS

UNLISTEN { name | * }

DESCRIPTION 描述

UNLISTEN 用于删除一个现有的已注册的 NOTIFY 事件。 UNLISTEN 取消当前 PostgreSQL 会话中的所有对通知条件 notifyname 监听。 特殊的条件通配符 * 则取消对当前会话的所有通知条件的监听。

NOTIFY [notify(7)] 包含一些对 LISTEN 和 NOTIFY 的使用的更广泛的讨论。  

PARAMETERS 参数

name

 通知条件名称(任意标识符)。
*

 所有此后端当前正在监听的注册都将被清除。

NOTES 注意


 如果你 UNLISTEN 一个你没有监听的事件,后端不会报错。


 每个后端在退出时都会自动执行 UNLISTEN *。  

EXAMPLES 例子


 注册一个:

LISTEN virtual;
NOTIFY virtual;
Asynchronous notification "virtual" received from server process with PID 8448.


 一旦执行了 UNLISTEN,以后的 NOTIFY 命令将被忽略:

UNLISTEN virtual;
NOTIFY virtual;
-- no NOTIFY event is received

COMPATIBILITY 兼容性


 SQL 标准里没有 UNLISTEN。  

SEE ALSO 参见

LISTEN [listen(7)], NOTIFY [notify(l)]

#p#

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 PostgreSQL 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 may 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(l)]

责任编辑:韩亚珊 来源: CMPP.net
相关推荐

2011-08-15 10:21:09

man中文man

2011-08-24 16:48:36

man中文man

2011-08-11 16:11:49

at中文man

2011-08-25 10:21:56

man.conf中文man

2011-08-25 17:53:26

stdio中文man

2011-08-25 17:58:41

stdout中文man

2011-08-25 17:24:54

puts中文man

2011-08-24 18:05:31

SHOW中文man

2011-08-25 18:34:55

ungetc中文man

2011-08-23 10:03:40

useradd中文man

2011-08-16 10:42:30

rmmod中文man

2011-08-23 16:24:57

smbmnt中文man

2011-08-23 10:29:02

chpasswd中文man

2011-08-23 10:34:22

convertquot中文man

2011-08-23 15:39:34

rpmbuild中文man

2011-08-24 15:48:38

INSERT中文man

2011-08-24 16:45:14

mailaddr中文man

2011-08-25 09:40:49

UPDATE中文man

2011-08-24 15:11:15

explain中文man

2011-08-24 15:29:06

grant中文man
点赞
收藏

51CTO技术栈公众号