Re: Plpsql connecting to more than one database?

From: Francisco Reyes <lists(at)natserv(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Plpsql connecting to more than one database?
Date: 2016-03-30 21:52:28
Message-ID: 56FC4A9C.1040203@natserv.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2016-03-30 22:12:44 Re: Plpsql connecting to more than one database?
Previous Message John R Pierce 2016-03-30 21:44:01 Re: Plpsql connecting to more than one database?