On Thu, Aug 18, 2011 at 3:40 AM, Dimitri Fontaine <dimitri@xxxxxxxxxxxxxx> wrote: > Chris Travers <chris.travers@xxxxxxxxx> writes: >> I want an email to go out to the ordering manager when the quantity I >> have of an item drops below the re-order point. I also want this >> email NOT to go out if the transaction rolls back. (Wait, the order >> of 50000 widgets I just processed rolled back because it isn't to a >> valid customer! We normally only sell 50000 per year anyway. No need >> for the email.) > > Just use PGQ and be done with it. You have transactional and > asynchronous behavior. Typically, a trigger would produce events in the > queue, and a separate daemon will consume the queue and send emails. > That actually looks quite helpful. Thanks. 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
