Re: Transactions across multiples databases - Mailing list pgsql-general

From Ron Johnson
Subject Re: Transactions across multiples databases
Date
Msg-id 1059686225.7508.555.camel@haggis
Whole thread Raw
In response to Transactions across multiples databases  (Sergio Pili <sergio.pili@spm.com.ar>)
List pgsql-general
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                                                      |
+-----------------------------------------------------------------+



pgsql-general by date:

Previous
From: Peter Nixon
Date:
Subject: CAST INTERVAL to INT??
Next
From: Tom Lane
Date:
Subject: Re: surppressing column names in COPY format