| From: | Scott Ribe <scott_ribe(at)elevated-dev(dot)com> |
|---|---|
| To: | Sim Zacks <sim(at)compulab(dot)co(dot)il> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Using Postgresql as application server |
| Date: | 2011-08-17 14:32:23 |
| Message-ID: | B7DD521E-7528-4E4C-9B51-5C6232E8120D@elevated-dev.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin 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(at)elevated-dev(dot)com
http://www.elevated-dev.com/
(303) 722-0567 voice
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Ribe | 2011-08-17 14:34:29 | Re: Using Postgresql as application server |
| Previous Message | Tom Browder | 2011-08-17 11:03:12 | Unable to login to a remote host running postgresql via phppgadmin |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Ribe | 2011-08-17 14:34:29 | Re: Using Postgresql as application server |
| Previous Message | Andre Lopes | 2011-08-17 14:06:30 | Re: How to install PGCRYPTO in PostgreSQL9 |