Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 2F66F633405 for ; Fri, 12 Mar 2010 11:24:48 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 73053-05 for ; Fri, 12 Mar 2010 15:24:28 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mailrelay102-out.ornis.com (mailrelay102-out.ornis.com [81.93.1.119]) by mail.postgresql.org (Postfix) with ESMTP id 2A55F632CCD for ; Fri, 12 Mar 2010 11:24:36 -0400 (AST) Received: from fsecure102.ornis.com ([192.168.162.102]) by mailrelay102-out.ornis.com (8.13.1/8.13.1) with ESMTP id o2CFOLtI004889 for ; Fri, 12 Mar 2010 16:24:33 +0100 Received: from unknown (HELO relay-ext.ornis.com) ([192.168.160.6]) by mailgate401.ornis.com with ESMTP; 12 Mar 2010 16:24:21 +0100 Received: from acteos127 ([80.79.155.178]) by relay-ext.ornis.com (8.12.9/8.12.3) with ESMTP id o2CFOD26012586 for ; Fri, 12 Mar 2010 16:24:15 +0100 Message-Id: <201003121524.o2CFOD26012586@relay-ext.ornis.com> From: "elias ghanem" To: Subject: Is DBLINK transactional Date: Fri, 12 Mar 2010 17:27:47 +0200 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0000_01CAC209.584BFE70" X-Mailer: Microsoft Office Outlook, Build 11.0.6353 Thread-Index: AcrB+I1nsyZfsJjWTvu0Jbk64FthQA== X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.601 tagged_above=-10 required=5 tests=AWL=-0.603, BAYES_50=0.001, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 201003/127 X-Sequence-Number: 37952 This is a multi-part message in MIME format. ------=_NextPart_000_0000_01CAC209.584BFE70 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 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 failed, would the update in the remote data base roll back or if the update in the remote data base failed, would the insert in the local data base roll back. If not, is there a way to make db link "transactional"? Thanks ------=_NextPart_000_0000_01CAC209.584BFE70 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable X-WrongBodyEncoding: 1 X-NoCharsWrongEncoded: 17

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 failed, would the update in the remote data base roll back or if the = update in the remote data base failed, would the insert in the local data base = roll back.

If not, is there a way to make db link = “transactional”?

Thanks

 

------=_NextPart_000_0000_01CAC209.584BFE70--