Re: Is DBLINK transactional

On Fri, 2010-03-12 at 12:07 -0500, Merlin Moncure wrote:
> of course.  You can always explicitly open a transaction on the remote
> side over dblink, do work, and commit it at the last possible moment.
> Your transactions aren't perfectly synchronized...if you crash in the
> precise moment between committing the remote and the local you can get
> in trouble.  The chances of this are extremely remote though.

If you want a better guarantee than that, consider using 2PC.

The problem with things that are "extremely remote" possibilities are
that they tend to be less remote than we expect ;)

Regards,
    Jeff Davis