| From: | Gerardo Herzig <gherzig(at)fmed(dot)uba(dot)ar> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
| Cc: | Filip Rembiałkowski <plk(dot)zuber(at)gmail(dot)com>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: transaction and triggers |
| Date: | 2008-01-18 15:33:56 |
| Message-ID: | 4790C6E4.4030002@fmed.uba.ar |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Alvaro Herrera wrote:
>Gerardo Herzig escribió:
>
>
>
>>Right. But today, that trigger do some other work, wich includes writing
>>some files to disk, so there is my problem. Crap, i guess i will have to
>>review the main logic.
>>
>>
>
>Probably it's better to move the actual file writing to a listener
>external process -- the transaction only does a NOTIFY, which is certain
>to be delivered only when the transaction commits. So if it aborts, no
>spurious write occurs.
>
>
>
Mmmhmm, sounds good...I will give it a try on monday. Now its beer time :)
Thanks all.
Gerardo
| From | Date | Subject | |
|---|---|---|---|
| Next Message | D'Arcy J.M. Cain | 2008-01-18 15:48:02 | Re: transaction and triggers |
| Previous Message | Alvaro Herrera | 2008-01-18 15:26:25 | Re: transaction and triggers |