2PC w/ dblink - Mailing list pgsql-general

From John R Pierce
Subject 2PC w/ dblink
Date
Msg-id 4CDAD8D3.5040604@hogranch.com
Whole thread Raw
Responses Re: 2PC w/ dblink  (Vick Khera <vivek@khera.org>)
List pgsql-general
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?



pgsql-general by date:

Previous
From: Jason
Date:
Subject: Re: PostgreSQL 8.2.3
Next
From: Tom Lane
Date:
Subject: Re: Vacuuming and reindexing tables that I don't own