FlyingZC opened a new issue, #24414: URL: https://github.com/apache/shardingsphere/issues/24414
## Feature Request Support to execute postgresql XA statement directly through proxy ### Is your feature request related to a problem? No. ### Describe the feature you would like. Currently, Proxy supports users to directly execute MySQL XA statements, using Proxy as an RM, and multiple Proxies can be executed by opening XA transactions externally. Postgresql/openGauss needs a simple adaptation. You can refer to `TransactionXAHandler`. Postgresql xa syntax is as follows: ```sql BEGIN; -- execute your sql statements -- xa prepare PREPARE TRANSACTION 'test'; -- xa phase 2 (commit or rollback) ROLLBACK PREPARED 'test'; COMMIT PREPARED 'test'; -- xa recovery select * from pg_prepared_xacts; ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
