You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Could I use pgcat in some way to 'share' or 'transfer' a connection, including a transaction, to a different process connected to the same 'pgcat' instance?
I'm trying to have two programming languages, in different processes on the same host, work on the same transaction: ie
one process does a BEGIN WORK
does some queries
invokes a rpc on the second proces and a token referring to the transaction
second process does some modifications, returns from the rpc
first process decides whether to commit or abort
I've looked at two-phase commits but these do not allow an atomic rollback
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
Could I use pgcat in some way to 'share' or 'transfer' a connection, including a transaction, to a different process connected to the same 'pgcat' instance?
I'm trying to have two programming languages, in different processes on the same host, work on the same transaction: ie
I've looked at two-phase commits but these do not allow an atomic rollback
Beta Was this translation helpful? Give feedback.
All reactions