NOTIFY

Hi,

I’m considering using NOTIFY to let my application react to changes in a table. If I only send the channel name without a payload, could I run into this issue:

1. The table is updated and a notification is sent to my app
2. My app reads the table, but hasn’t sent acknowledgement of the notification yet
3. The table is updated again, but the notification gets dropped because it’s the same as (1), which hasn’t been acknowledged by the app

If this happened then there would be new data in my table but my app wouldn’t read it until the next time there was an update.

Thanks

This email message is confidential, may be legally privileged and is intended for the exclusive use of the addressee. If you received this message in error or are not the intended recipient, you should destroy the email message and any attachments or copies, and you are prohibited from retaining, distributing, disclosing or using any information contained. Please inform us of the delivery error by return email. Thank you for your cooperation.

Le présent message électronique est confidentiel et peut être couvert par le secret professionnel. Il est à l’usage exclusif du destinataire. Si vous recevez ce message par erreur ou si vous n’en êtes pas le destinataire prévu, vous devez détruire le message et toute pièce jointe ou copie et vous êtes tenu de ne pas conserver, distribuer, divulguer ni utiliser tout renseignement qu’il contient. Veuillez nous informer de toute erreur d’envoi en répondant à ce message. Merci de votre collaboration.