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