> 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.
>
OK, so far so good. Now, just to be clear, are you saying in addition
that the dblink(), insert,commit stuff has to be all "in line" in the
original psql script and can't be in a pl/xxxx language?