Different connections in postgres (and in every other DB engine I heard of) can never share the same transaction.
As far as I can see, the only way to do what you want is to rethink your architechture so that the clients never talk directly to the database, and always go through the app server... or, the other way around - get rid of the app server, and just have every client go to the database directly. You can' thave it both ways.
Dima
Daniel Schuchardt wrote:
Hi @ all,
Our software consists of a Client-Side App and a Application Server. Every client owns a direct connection to the PSql-Server and for every Client the Application-Server also creates a connection to the PSql-Server. The problem is that it is nescesary that the Client and the Application-Server are in the same transaction. But how say connection x to be in the same transaction like connection y?
Thanks for help,
Daniel
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
