Re: Using Postgresql as application server - Mailing list pgsql-general

From Scott Ribe
Subject Re: Using Postgresql as application server
Date
Msg-id B7DD521E-7528-4E4C-9B51-5C6232E8120D@elevated-dev.com
Whole thread Raw
In response to Re: Using Postgresql as application server  (Sim Zacks <sim@compulab.co.il>)
List 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
stillsend 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





pgsql-general by date:

Previous
From: Murat Kabilov
Date:
Subject: Stored procedure name
Next
From: Scott Ribe
Date:
Subject: Re: Using Postgresql as application server