Re: Nested transaction workaround? - Mailing list pgsql-general

From John Sidney-Woollett
Subject Re: Nested transaction workaround?
Date
Msg-id 4305.192.168.0.64.1074009352.squirrel@mercury.wardbrook.com
Whole thread Raw
In response to Re: Nested transaction workaround?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom Lane said:
> I wouldn't call it "nested" transactions: the remote transactions would
be committed, and would stay committed even if you roll back the caller.

Ah, that's true. This means the dblink could be used to provide
functionality equivalent to Oracle's #PRAGMA AUTONOMOUS directive.

Thanks for clearing that up.

John




pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Any real known bugs about wrong selects?
Next
From: "Keith C. Perry"
Date:
Subject: Re: cryptography, was Drawbacks of using BYTEA for PK?