Transactions across multiples databases

Started by Sergio Piliover 22 years ago2 messagesgeneral
Jump to latest
#1Sergio Pili
sergio.pili@spm.com.ar

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

#2Ron Johnson
ron.l.johnson@cox.net
In reply to: Sergio Pili (#1)
Re: Transactions across multiples databases

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                                                      |
+-----------------------------------------------------------------+