[GitHub] [shardingsphere] FlyingZC opened a new issue, #24414: Support to execute postgresql XA statement directly through proxy

["FlyingZC (via GitHub)" <gi...@apache.org>]

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: notifications-unsubscribe@shardingsphere.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] strongduanmu commented on issue #24414: [Feature]Support to execute postgresql XA statement directly through proxy

["strongduanmu (via GitHub)" <gi...@apache.org>]

strongduanmu commented on issue #24414:
URL: https://github.com/apache/shardingsphere/issues/24414#issuecomment-1462049548

   @clbigdata Welcome, I just assign this issue to you.


-- 
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: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] clbigdata commented on issue #24414: [Feature]Support to execute postgresql XA statement directly through proxy

["clbigdata (via GitHub)" <gi...@apache.org>]

clbigdata commented on issue #24414:
URL: https://github.com/apache/shardingsphere/issues/24414#issuecomment-1461941426

   I want try it


-- 
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: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org