Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mpW8G-0003Ka-CW for pgsql-interfaces@arkaria.postgresql.org; Tue, 23 Nov 2021 13:46:48 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mpW8E-0002rW-AY for pgsql-interfaces@arkaria.postgresql.org; Tue, 23 Nov 2021 13:46:46 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mpW8E-0002rN-3A for pgsql-interfaces@lists.postgresql.org; Tue, 23 Nov 2021 13:46:46 +0000 Received: from mail2.fastcrypt.com ([192.99.154.132]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mpW85-0002TU-3c for pgsql-interfaces@lists.postgresql.org; Tue, 23 Nov 2021 13:46:45 +0000 Received: from mail-ed1-f48.google.com (mail-ed1-f48.google.com [209.85.208.48]) by mail2.fastcrypt.com (Postfix) with ESMTPSA id 8B17D232CD8 for ; Tue, 23 Nov 2021 08:46:34 -0500 (EST) Received: by mail-ed1-f48.google.com with SMTP id w1so92503989edc.6 for ; Tue, 23 Nov 2021 05:46:34 -0800 (PST) X-Gm-Message-State: AOAM531KthBLQfVCx7CNQiX92lKGXxZcTbpAV9k4+UoOlFMBgczGU/W6 pQLJYn8zA9C21HaWKy4mM9b/lgrN7p1bE4KBlcQ= X-Google-Smtp-Source: ABdhPJwf23aoyNnT7fFszmn4p9tyAKelQZkHCclO1E+jGTsqPpkBzI/okv8cXB5KiBwLLsVFtZQH6Cu3IhpjkPo5D1M= X-Received: by 2002:a05:6402:10cd:: with SMTP id p13mr9331222edu.111.1637675193367; Tue, 23 Nov 2021 05:46:33 -0800 (PST) MIME-Version: 1.0 References: <163765033620.23200.12862742917966078276@malur.postgresql.org> In-Reply-To: From: Dave Cramer Date: Tue, 23 Nov 2021 08:46:16 -0500 X-Gmail-Original-Message-ID: Message-ID: Subject: Re: PostgreSQL XA resource manager for C/C++ apps To: trn nrjn Cc: pgsql-interfaces@lists.postgresql.org Content-Type: multipart/alternative; boundary="0000000000002884c905d174f8f3" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000002884c905d174f8f3 Content-Type: text/plain; charset="UTF-8" On Tue, 23 Nov 2021 at 02:10, trn nrjn wrote: > Hi, > > Could you please assist with the following when not using ODBC/JDBC? > > 1. Does PostgreSQL participate as an XA resource manager in an XA > transaction managed by a transaction manager (eg: Oracle Tuxedo) for C/C++ > applications? > > 2. If so, can you please advice - > > 2.1. PostgreSQL xa_open string to be used for PostgreSQL > XA resource manager by C/C++ applications managed by a a transaction > manager (eg: Oracle Tuxedo)? > > 2.2. PostgreSQL XA switch structure (xa_switch_t) to be > used (similar to xaosw for Oracle database)? > > 2.3. Is there any link that I can use as reference for > PostgreSQL XA resource manager? > > Thanks and regards > Shuba > opengauss-mirror/openGauss-connector-odbc: openGauss odbc connector (github.com) seems to have one. Dave Cramer www.postgres.rocks --0000000000002884c905d174f8f3 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable


On Tue, 23 Nov 2021 at 02:10, trn nrjn <shuba14@gmail.com> wrote:
Hi,

= Could you please assist with the following when not using ODBC/JDBC?

1. Does PostgreSQL participate as an XA resource manager in an XA tra= nsaction managed by a transaction manager (eg: Oracle Tuxedo) for C/C++ app= lications?

2. If so, can you pleas= e advice -

=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 2.1. = PostgreSQL xa_open string to be used for PostgreSQL XA resource manager by = C/C++ applications managed by a a transaction manager (eg: Oracle Tuxedo)?<= /p>

=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 2.2. PostgreSQL X= A switch structure (xa_switch_t) to be used (similar to xaosw for Oracle da= tabase)?

=C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 2.3.=C2=A0Is there any link that I can use as reference = for =C2=A0PostgreSQL XA resource manager?


<= /div>
Thanks and regards=C2=A0
Shub= a=C2=A0


=
www.p= ostgres.rocks

--0000000000002884c905d174f8f3--