Scott Mead <sco...@openscg.com> writes:
>> On Oct 6, 2015, at 05:38, Steve Pritchard <steve.pritch...@bto.org> wrote:
>> [ how to fake an autonomous transaction? ]
> It's hacky, and, I haven't tried it in a few years. Setup a foreign table
> that resides in the same database. When you write to the foreign table, it
> will be using a 'loopback' connection, and that transaction will be able to
> commit because it is a separate connection.
> To be fair, I haven't actually done this since the days of dblink, I
> *believe* it should work with fdw though.
My recollection is that you can do this with dblink, but *not* with FDWs
--- or at least, not with postgres_fdw. The latter is smart enough to
roll back your remote transaction when the local one rolls back.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
