Thread: Transactions across multiples databases

Transactions across multiples databases

From
Sergio Pili
Date:
Hello:

I need to modify diferent tables in multiples databases in one transaction.
Can i do it whitout lost integrity in all databases if "rollback" is
executed?

Thanks,

Sergio Pili

Re: Transactions across multiples databases

From
Ron Johnson
Date:
On Thu, 2003-07-31 at 13:02, Sergio Pili wrote:
> Hello:
>
> I need to modify diferent tables in multiples databases in one transaction.
> Can i do it whitout lost integrity in all databases if "rollback" is
> executed?

That's 2PC (two phase commit), and it's on the on the TODO list.
http://developer.postgresql.org/todo.php

--
+-----------------------------------------------------------------+
| Ron Johnson, Jr.        Home: ron.l.johnson@cox.net             |
| Jefferson, LA  USA                                              |
|                                                                 |
| "I'm not a vegetarian because I love animals, I'm a vegetarian  |
|  because I hate vegetables!"                                    |
|    unknown                                                      |
+-----------------------------------------------------------------+