Hi,
I need to use two phase commit transaction. For connection to other databases I use contribution dblink. But I don't know how to use correctly PREPARE TRANSACTION. I need to rollback transaction on others db's when one fails. But how I'll know it? Documentation says nothing about it. How can I get result if PREPARE TRANSACTION failed or passed?
If some links or help you have, I will be thanks a lot.
David