Lists: | pgsql-general |
---|
From: | Sergio Pili <sergio(dot)pili(at)spm(dot)com(dot)ar> |
---|---|
To: | "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org> |
Subject: | Transactions across multiples databases |
Date: | 2003-07-31 18:02:10 |
Message-ID: | 069B887B914BD51180420004AC33E2E80A4787E8@MAILSVR_A |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
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
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 |
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 |
+-----------------------------------------------------------------+