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 1mqCXY-0006Cs-5b for pgsql-interfaces@arkaria.postgresql.org; Thu, 25 Nov 2021 11:03:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mqCXV-0003Jy-Ld for pgsql-interfaces@arkaria.postgresql.org; Thu, 25 Nov 2021 11:03:41 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mqCXV-0003Jp-7Y for pgsql-interfaces@lists.postgresql.org; Thu, 25 Nov 2021 11:03:41 +0000 Received: from mail2.fastcrypt.com ([192.99.154.132]) by makus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mqCXS-00006L-2p for pgsql-interfaces@lists.postgresql.org; Thu, 25 Nov 2021 11:03:39 +0000 Received: from mail-ed1-f49.google.com (mail-ed1-f49.google.com [209.85.208.49]) by mail2.fastcrypt.com (Postfix) with ESMTPSA id 0B460232CD8 for ; Thu, 25 Nov 2021 06:03:34 -0500 (EST) Received: by mail-ed1-f49.google.com with SMTP id v1so23921735edx.2 for ; Thu, 25 Nov 2021 03:03:34 -0800 (PST) X-Gm-Message-State: AOAM5319jMSuf+SYEckVHy59guZ7AkjGXnyYQOQq4W+stm3FERYX6T4S bAzAOSoDlUwBa/zYN+vxtmYqo7HP42QP0JVJ3wE= X-Google-Smtp-Source: ABdhPJzQUA8s1E5PRvSwdGcsPwlkZ1bp66EQsZGGpyEKoJDiS6YtoOQBejh3g5k6w29fKAKTh5hgMQ59O0faJcuRoDM= X-Received: by 2002:a17:907:3d88:: with SMTP id he8mr30098089ejc.565.1637838212189; Thu, 25 Nov 2021 03:03:32 -0800 (PST) MIME-Version: 1.0 References: <163765033620.23200.12862742917966078276@malur.postgresql.org> In-Reply-To: From: Dave Cramer Date: Thu, 25 Nov 2021 06:03:14 -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="000000000000d653ce05d19aecbb" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000d653ce05d19aecbb Content-Type: text/plain; charset="UTF-8" On Thu, 25 Nov 2021 at 03:55, trn nrjn wrote: > Thanks Dave. This seems to use ODBC whereas I am looking for XA support in > PostgreSQL C/C++ client library itself, something similar to what Oracle > provides in the OCI library. Can you please suggest if there is one? > the project does not provide one. If that is the question. I am not aware of any either. Sorry . Dave Cramer www.postgres.rocks > > > Thanks. > > On Tue, 23 Nov 2021 at 7:16 PM, Dave Cramer > wrote: > >> >> >> 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 >> >> --000000000000d653ce05d19aecbb Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

<= div dir=3D"ltr" class=3D"gmail_signature">

=


On Thu, 25 Nov 2021 at 03:55, trn nrjn <shuba14@gmail.com> wrote:
Thanks Dave. This s= eems to use ODBC whereas I am looking for XA support in PostgreSQL C/C++ cl= ient library itself, something similar to what Oracle provides in the OCI l= ibrary. Can you please suggest if there is one?

the project does not=C2=A0 provide one.=C2=A0 If that is = the question. I am not aware of any either. Sorry .

Dave Cramer
www.postgres.rocks

<= br>
Thanks.

On Tue, 23 Nov 2021 at 7:16 PM, Dave Cramer <davecramer@postgres.rocks= > wrote:


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

<= div dir=3D"auto">Could you please assist with the following when not using = ODBC/JDBC?

1. Does PostgreSQL participate as an XA resource man= ager in an XA transaction managed by a transaction manager (eg: Oracle Tuxe= do) for C/C++ applications?

2. If = so, can you please 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 resou= rce manager by C/C++ applications managed by a a transaction manager (eg: O= racle Tuxedo)?

=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 XA switch structure (xa_switch_t) to be used (similar to xaos= w for Oracle database)?

=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?


Thanks and regards=C2=A0
Shuba=C2=A0

<= /div>
=

=C2=A0Dave = Cramer
www.postgres.rocks<= /div>

--000000000000d653ce05d19aecbb--