We have an application that is using dblink from within trigger
procedures to send data to other postgres databases. Its implementing
a highly application specific sort of data replication.
My developers are complaining about the lack of support for 2 phase
commit in this scenario. Can we get any mileage on PREPARE
TRANSACTION in a dblink sort of environment like this?