Re: Transactions across multiples databases

From: Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Transactions across multiples databases
Date: 2003-07-31 21:17:05
Message-ID: 1059686225.7508.555.camel@haggis
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)l(dot)johnson(at)cox(dot)net |
| Jefferson, LA USA |
| |
| "I'm not a vegetarian because I love animals, I'm a vegetarian |
| because I hate vegetables!" |
| unknown |
+-----------------------------------------------------------------+

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-07-31 21:21:59 Re: surppressing column names in COPY format
Previous Message Robert Treat 2003-07-31 21:13:34 Re: surppressing column names in COPY format