Horton

Re: Using Postgresql as application server

Scott Ribe <scott_ribe@elevated-dev.com>

View thread View on postgr.es
From: Scott Ribe <scott_ribe@elevated-dev.com>
To: Sim Zacks <sim@compulab.co.il>
Cc: pgsql-general@postgresql.org
Date: 2011-08-17T14:32:23Z
Lists: pgsql-general 
On Aug 17, 2011, at 12:53 AM, Sim Zacks wrote:

> In your scenario, if you send the NOTIFY message and then you roll back the transaction, the helper application will still send the email.

How? NOTIFY doesn't get delivered until the transaction commits.

-- 
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice