pgtap icon indicating copy to clipboard operation
pgtap copied to clipboard
verified publisher icon theory

Testing listen/notify functionality

Open splatch opened this issue 2 months ago • 1 comments

Hello, I have a question - is it possible to use pgtap for asynchronous events posted by pg_notify? I have a case where I would like to confirm trigger result which is an event, not a full blown database object.

splatch avatar Oct 22 '25 14:10 splatch

If you trigger the event from within pgTAP, the only way I know of to use it to LISTEN for such events is to use dblink within the test to LISTEN.

theory avatar Oct 22 '25 19:10 theory