Re: transaction and triggers - Mailing list pgsql-sql

From Gerardo Herzig
Subject Re: transaction and triggers
Date
Msg-id 4790C6E4.4030002@fmed.uba.ar
Whole thread Raw
In response to Re: transaction and triggers  (Alvaro Herrera <alvherre@commandprompt.com>)
List 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


pgsql-sql by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: transaction and triggers
Next
From: "D'Arcy J.M. Cain"
Date:
Subject: Re: transaction and triggers