Martijn Tonies wrote:

>>>>>OTOH, is it possible for all these different DB connections to share
>>>>>
>>>>>
>the
>
>
>>>>>same transaction across all the threads?
>>>>>
>>>>>Thanks!
>>>>>
>>>>>Jonathan Neve.
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>NO
>>>>
>>>>
>>>>
>>>>
>>>You can, however, create a cross-database transaction using
>>>two-phase commit :-)
>>>
>>>
>>>
>>>
>>That sounds very much like what I was proposing... What's the difference?
>>
>>
>
>A cross database transaction is started for each database, not simply
>shared between database.
>
>

I'm not talking about having multiple databases, but rather, multiple
database connections to the same database, one per thread. Then, I would
like to have a "cross-database transaction" across all the threads. Is
this not possible?

Thanks!
Jonathan Neve.


[Non-text portions of this message have been removed]