Does Listen/Notify work on Neon?
I've written a short test using Node.js and as far as I can tell the answer is no: there is no error, but events are never delivered. Is there some trick to this that I'm missing or does it simply not work at all?
4 Replies
exotic-emeraldOP•5mo ago
This guide seems to suggest it should but it doesn't seem to https://neon.tech/guides/pg-notify
Neon
Real-Time Notifications using pg_notify with Neon Postgres - Neon G...
A step-by-step guide describing how to implement real-time notifications using pg_notify in Postgres
exotic-emeraldOP•5mo ago
Just tried the same test on Supabase, seems to work fine.
conscious-sapphire•5mo ago
@ciphergoth can you share what problem you ran into?
Per your code, it does not have the trigger function that'd emit the notify event as mentioned in the guide.