On Tue, Apr 1, 2008 at 7:56 PM, carty mc <cartymc3(at)yahoo(dot)com> wrote:
> In this case the updates that were made using dblink_exec are not getting
> rolled back in Database B.
And they won't be. dblink isn't transactional in that way. Your best
bet is to put all the data into one database and use schemas to
separate the table namespaces and control user acccess.
Failing that, changing the application to update both databases itself
and using 2PC might be an option.
-Doug