PostgreSQL listen/notify and the method stack

Nick Renders omnis1 at arcict.com
Thu Nov 23 08:48:09 UTC 2023


Hello fellow Omnis-Potents,

I have noticed that when implementing the $listen and $notify methods of the PostgreSQL DAM, the $notify method actually interrupts the current method stack. So when Omnis is executing a certain method, the notification will cut in, execute the $notify method, and return to the previous method where it left off. At least that is what I've come to understand after doing some tests.

I'm not very comfortable with the $notify method interrupting any possible method at any possible time. Has anyone encountered this before? Does anyone have any good tips and/or tricks on managing listeners/notifiers?

Best regards,

Nick Renders


More information about the omnisdev-en mailing list