Re: Actions requiring commit

On Mon, Feb 15, 2010 at 5:14 PM, Lee Horowitz <leeh(at)panix(dot)com> wrote:
> My problem is that I'be been told that I can use dblink() to make a second
> connection to the same database, and then, on that second connection, do
> an
> insert to some table and issue a commit which will make the data in that
> commit visible to other sessions, but NOT commit any pending data on the
> first connection.
>

That's correct. The database server process handling the second
connection won't know anything about the outer transaction. All it
knows is that it received this connection with this insert and then
was asked to commit it. The outer transaction can abort or commit and
it won't affect the status of the insert that the dblink connection
made.

You could see some weird effects if you try to look at that newly
inserted row in the outer transaction, but that's just because it was
inserted after your transaction started.

--
greg