Re: [PERFORM] Is DBLINK transactional

2010-03-16 Thread Chris Browne
cr...@postnewspapers.com.au (Craig Ringer) writes: On 13/03/2010 5:54 AM, Jeff Davis wrote: On Fri, 2010-03-12 at 12:07 -0500, Merlin Moncure wrote: of course. You can always explicitly open a transaction on the remote side over dblink, do work, and commit it at the last possible moment.

Re: [PERFORM] Is DBLINK transactional

2010-03-15 Thread Hannu Krosing
On Sat, 2010-03-13 at 20:10 +0800, Craig Ringer wrote: On 13/03/2010 5:54 AM, Jeff Davis wrote: On Fri, 2010-03-12 at 12:07 -0500, Merlin Moncure wrote: of course. You can always explicitly open a transaction on the remote side over dblink, do work, and commit it at the last possible

Re: [PERFORM] Is DBLINK transactional

2010-03-13 Thread Craig Ringer
On 13/03/2010 5:54 AM, Jeff Davis wrote: On Fri, 2010-03-12 at 12:07 -0500, Merlin Moncure wrote: of course. You can always explicitly open a transaction on the remote side over dblink, do work, and commit it at the last possible moment. Your transactions aren't perfectly synchronized...if you

[PERFORM] Is DBLINK transactional

2010-03-12 Thread elias ghanem
Hi, I am using dblink to read data from a remote data base, insert these data in the local database, update the red data in the remote database then continue to do some other work on the local database in the same transaction. My question is : Is db link transactional; If the local transaction

Re: [PERFORM] Is DBLINK transactional

2010-03-12 Thread Merlin Moncure
On Fri, Mar 12, 2010 at 10:27 AM, elias ghanem e.gha...@acteos.com wrote: Hi, I am using dblink to read data from a remote data base, insert these data in the local database, update the red data in the remote database then continue to do some other work on the local database in the same

Re: [PERFORM] Is DBLINK transactional

2010-03-12 Thread Jeff Davis
On Fri, 2010-03-12 at 12:07 -0500, Merlin Moncure wrote: of course. You can always explicitly open a transaction on the remote side over dblink, do work, and commit it at the last possible moment. Your transactions aren't perfectly synchronized...if you crash in the precise moment between