| From: | carty mc <cartymc3(at)yahoo(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | dblink ,dblink_exec not participating in a Transaction?? |
| Date: | 2008-04-01 22:28:19 |
| Message-ID: | 678727.2902.qm@web58514.mail.re3.yahoo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
How I can make dblink to participate in transaction so that remote changes made by dblink can only be committed if only local transaction succeds.
Here is my current scenario:
I am using two databases A & B. In Database A, I have trigger procedure written for a Table . In this trigger procedure, I use dblink_exec to update a table in the other database B.
The problem I am having right now is my trigger procedure currently participates in a transaction. If Transaction rollsback: whatever trigger procedure modified in database A is getting rolled back whereas Chages made to a table in Database B using dblink_exec are not.
Note: Transaction can be rolled back due to excpetions any where from main db client which updates a table in database A .
So my question is there a way to tell dblink_exec to participate in a Transaction. This way commits wont go to table in database B until transaction completed succesfully.
I appreciate any help,
thanks,
---------------------------------
You rock. That's why Blockbuster's offering you one month of Blockbuster Total Access, No Cost.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | x asasaxax | 2008-04-01 22:43:36 | Primary Key with auto increment field |
| Previous Message | Adam Rich | 2008-04-01 21:55:28 | Re: Update Join ? |