本文介绍了通知如何在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中工作?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

10-14 05:44