Re: Plpsql connecting to more than one database?

Поиск
Список
Период
Сортировка
От Francisco Reyes
Тема Re: Plpsql connecting to more than one database?
Дата
Msg-id 56FC4A9C.1040203@natserv.net
обсуждение исходный текст
Ответ на Re: Plpsql connecting to more than one database?  (John R Pierce <pierce@hogranch.com>)
Ответы Re: Plpsql connecting to more than one database?  (John R Pierce <pierce@hogranch.com>)
Список 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 по дате отправления:

Предыдущее
От: John R Pierce
Дата:
Сообщение: Re: Plpsql connecting to more than one database?
Следующее
От: John R Pierce
Дата:
Сообщение: Re: Plpsql connecting to more than one database?