On Tue, Apr 1, 2008 at 7:56 PM, carty mc <[EMAIL PROTECTED]> 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
