Re: Plpsql connecting to more than one database? - Mailing list pgsql-general

From Francisco Reyes
Subject Re: Plpsql connecting to more than one database?
Date
Msg-id 56FC4A9C.1040203@natserv.net
Whole thread Raw
In response to Re: Plpsql connecting to more than one database?  (John R Pierce <pierce@hogranch.com>)
Responses Re: Plpsql connecting to more than one database?
List pgsql-general
On 03/30/2016 05:44 PM, John R Pierce wrote:
> and what if commit db2 fails for any number of reasons?  you've
> already committed db1, so you can't roll it back.      this sort of
> work requires '2pc' (2-phase commit), which is rather gnarly to
> implement.

You mean when executing the actual commit? Wouldn't that be a rare
ocurrence? Right now they are doing each DB independently and then doing
a cleanup if something goes wrong so even if there are times where the
"commit db2" fails, it would not be any worse than what they have now.


pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: Plpsql connecting to more than one database?
Next
From: John R Pierce
Date:
Subject: Re: Plpsql connecting to more than one database?