Обсуждение: Two-fase-commit

Поиск
Список
Период
Сортировка

Two-fase-commit

От
Wagner Sales
Дата:
Hi!
I have a customer asking to me: is possible one app whit two-fase-commit
transactions using posgresql+informix?
Well, I was searched in the web and the postgresql web site, but I
wasn't found nothing about. I hope this is the correct list to post this
ask, and, of course, someone to help me ;).


thks


Re: Two-fase-commit

От
Bruce Momjian
Дата:
No, I don't think that is possible.  We don't even have 2-phase commit
between PostgreSQL backends.

---------------------------------------------------------------------------

Wagner Sales wrote:
> Hi!
> I have a customer asking to me: is possible one app whit two-fase-commit
> transactions using posgresql+informix?
> Well, I was searched in the web and the postgresql web site, but I
> wasn't found nothing about. I hope this is the correct list to post this
> ask, and, of course, someone to help me ;).
>
>
> thks
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>                http://archives.postgresql.org
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Re: Two-fase-commit

От
aurelien.dehay@laposte.net (Aurélien DEHAY)
Дата:
pgman@candle.pha.pa.us (Bruce Momjian) writes:

> No, I don't think that is possible.  We don't even have 2-phase commit
> between PostgreSQL backends.
>
> ---------------------------------------------------------------------------
>
> Wagner Sales wrote:
>> Hi!
>> I have a customer asking to me: is possible one app whit two-fase-commit
>> transactions using posgresql+informix?
>> Well, I was searched in the web and the postgresql web site, but I
>> wasn't found nothing about. I hope this is the correct list to post this
>> ask, and, of course, someone to help me ;).
>>


It's surely possible, but as Postgres isn't a transactionnal monitor,
It could not handle 2-phase commit alone. With a TM like Tuxedo, you
(well, he) surely can do this.

[...]

--
Aurélien DEHAY         http://logicielslibres.info