On Tue, Aug 16, 2011 at 11:53 PM, Sim Zacks <sim@xxxxxxxxxxxxxx> wrote: > We are doing this same sort of thing now. If the transaction goes through, > the email record gets written to a table. We have a cron job that calls a > database function that processes all emails that have not been processed > yet. If the transaction gets rolled back, the email record does not get > written to the table and the email does not get sent. > In your scenario, if you send the NOTIFY message and then you roll back the > transaction, the helper application will still send the email. IOW, doing > this outside of the database can more easily break your transactional > integrity. > Notify hits on commit, right? Best Wishes, Chris Travers -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
