gisce / ws_transactions

WebServices Transactions for OpenObject
http://code.gisce.net/ws_transactions
GNU General Public License v3.0
2 stars 2 forks source link

Support for TPC Protocol #13

Open ecarreras opened 1 year ago

ecarreras commented 1 year ago

This will allow us to be multi-process as the transaction id management is in PostgreSQL and not in ERP server.

PostgreSQL Two Phase Commit Documentation Pycopg2

ecarreras commented 1 year ago

I think better of tpc, which only allow us to 'commit' changes from other system, we need to load the transaction and continue from that in other process.

We should try to use:

pg_export_snapshot and then command SET TRANSACTION

SET TRANSACTION SNAPSHOT _snapshot_id_