How notify works in PostgreSQL?

Question

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?

No "function" is triggered. Any session that registered itself as a listeren will be notified. — user330315
– user330315, Commented Apr 25, 2017 at 7:29
@a_horse_with_no_name That I know.. but where I can see who listen to that? I'm debugging the code and i'm stuck due to this — avi
– avi, Commented Apr 25, 2017 at 7:31
@pozs pg_listening_channels shows channels, that current_session listens to, while OP wants to list sessions that listen to his channel — Vao Tsun
– Vao Tsun, Commented Apr 25, 2017 at 7:56

Laurenz Albe · Accepted Answer · 2017-04-25 09:34:52Z

1

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.

answered Apr 25, 2017 at 9:34

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

avi Over a year ago

sessions only communicate with the server, not with each other. This notify trigger some action from the server but I can't figure out which.

Laurenz Albe Over a year ago

That depends on what API you are using.

avi Over a year ago

How do I know that? I'm using PostgreSQL 9.3

Laurenz Albe Over a year ago

Meh. But how do you use it? On the command line or from a program? In which programming language is the program that accesses PostgreSQL written, and which library does it use to access PostgreSQL?

avi Over a year ago

I don't know. This is a code written by someone who is not here anymore.. If there is a way to check please let me know how. This is why i'm lost. I can't figure out who and where it's handled.

|

Collectives™ on Stack Overflow

How notify works in PostgreSQL?

1 Answer 1

7 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related