| From: | "John Sidney-Woollett" <johnsw(at)wardbrook(dot)com> |
|---|---|
| To: | "Oleg Lebedev" <oleg(dot)lebedev(at)waterford(dot)org> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: dblink: rollback transaction |
| Date: | 2004-02-05 07:49:02 |
| Message-ID: | 4248.192.168.0.64.1075967342.squirrel@mercury.wardbrook.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Oleg Lebedev said:
> Is there a way to rollback a dblink transaction?
> Say, I delete some data from the remote database, but I don't want this
> to be visible untill the data is inserted in the current database. And
> if the insertion of data in the current database throws an error, I want
> to rollback the dblink transaction, which should restore data in its
> original remote location.
What about doing the insert first, and then issuing the delete via the
dblink? If the insert fails and the transaction rolls back then the
deletion in the remote database will never have been done.
John Sidney-Woollett
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Garamond | 2004-02-05 08:30:07 | Can LIKE use indexes or not? |
| Previous Message | Hadley Willan | 2004-02-05 05:49:14 | Re: Improving performance with a Function instead of a |