Re: ON-COMMIT trigger (question)
Date: 1995/06/20
Message-ID: <3s5seo$php_at_newsbf02.news.aol.com>#1/1
In article <192747939wnr_at_artemis.demon.co.uk>, "C:DEMONSPOOLMAIL" <tim_at_artemis.demon.co.uk> writes:
>In article: <1995Jun15.160110.14143_at_ericsson.se> "wei he (martletts)"
><etlwihe> writes:
>>
>> Hi
>> Can anybody confirm the following statement
>>
>> "If on-commit trigger fails, a rollback will take place."
>>
>> Thanks
>>
>> Wei
>>
>>
>>
>
> The following is from the manual, it would appear that it doesn't do a
>rollback.
>
>
<snip>
>On Failure: Aborts Post and Commit processing
I think that is does. The whole point, if I understand correctly, is that if any part of the Pre-On-Post trigger logic fails the entire transaction is rolled back. That would seem to be implied by the "On Failure:" message contained in the "man page" in the last post.
Regards,
Dave Rathbun
DRathbun_at_AOL.com
Received on Tue Jun 20 1995 - 00:00:00 CEST