[Feature]Support to execute postgresql XA statement directly through proxy

[FlyingZC]

Feature Request

Hi community. We want to support to execute postgresql XA statement directly through proxy. If you are interested, welcome to complete it.

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:

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;

[chenlong1993]

I want try it

[strongduanmu]

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