Re: [GENERAL] 2PC w/ dblink

2010-11-11 Thread John R Pierce
On 11/11/10 5:17 AM, Vick Khera wrote: On Wed, Nov 10, 2010 at 12:39 PM, John R Pierce wrote: 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? Yes, that's an

Re: [GENERAL] 2PC w/ dblink

2010-11-11 Thread Vick Khera
On Wed, Nov 10, 2010 at 12:39 PM, John R Pierce wrote: > 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? > Yes, that's an ideal case for this. We use it ou

[GENERAL] 2PC w/ dblink

2010-11-10 Thread John R Pierce
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