Re: Re: a primer on trigger?

On Fri, May 04, 2001 at 12:59:54PM -0700, Stephan Szabo wrote:

> The problem is that you have the problem in reverse then, unless what's
> done by the trigger is "optional" sortof. What happens if there is an
> error, and you can't do the outside operation? You once again end up
> out of sync with the database, but this time the outside thing is missing
> the records.  You still need something to come in every so often and make
> sure stuff is correct.
>
> This whole class of things is just ugly.

I'm a little weak on database theory, but isn't this what two-phase
commit is for?

Chris

--
chris@mt.sri.com -----------------------------------------------------
Chris Jones                                    SRI International, Inc.
                                                           www.sri.com