Mike Mascari wrote:
How can dblink() possibly be used safely for non-readonly transactions without a full implementation of a two-phase commit protocol? What happens when the remote server issues the COMMIT and then the local server crashes?

It can't be used safely if you're trying to ensure a distributed transaction either fails or commits. At least I can't think of a way without two-phase commits implemented.

But depending on your scenario, just being sure that the remote transaction fails or succeeds as a unit may be all you care about.


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to