本文介绍了通知如何在PostgreSQL中工作?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有一个书面函数,它的最后一行是:
I have a written function that it's last row is:
Notify ALLOCWARE;
我知道这是通过某种渠道发出的消息。
在哪里可以找到由于该命令而触发的功能?
I know that this is a message via some sort of channel.Where I can find which function is triggered due to this command?
推荐答案
给定通道的列表正在监听的会话存储在后端的私有内存中( src / backend / commands / async.c
中的 listenChannels
),因此无法确定其他会话正在收听哪些频道。
The list of channels on which a given session is listening is stored in the backend's private memory (listenChannels
in src/backend/commands/async.c
), so there is no way to figure out on which channels other sessions are listening.
这篇关于通知如何在PostgreSQL中工作?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!