On Thu, Aug 18, 2011 at 3:40 AM, Dimitri Fontaine
<dimitri@2ndquadrant.fr> wrote:
> Chris Travers <chris.travers@gmail.com> 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