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 1mqAX8-0000nn-7K for pgsql-interfaces@arkaria.postgresql.org; Thu, 25 Nov 2021 08:55:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mqAX5-0006iE-GM for pgsql-interfaces@arkaria.postgresql.org; Thu, 25 Nov 2021 08:55:07 +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 1mqAX4-0006h1-UJ for pgsql-interfaces@lists.postgresql.org; Thu, 25 Nov 2021 08:55:07 +0000 Received: from mail-oi1-x233.google.com ([2607:f8b0:4864:20::233]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1mqAX0-0007XF-W1 for pgsql-interfaces@lists.postgresql.org; Thu, 25 Nov 2021 08:55:05 +0000 Received: by mail-oi1-x233.google.com with SMTP id bk14so11212100oib.7 for ; Thu, 25 Nov 2021 00:55:02 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=zqkx5Wa7xZWMkMCn1hqymNWHmYh7PIZ+YscvAx/RdYE=; b=KT5azwR9aM0H86AzWOv1yjtdXoNOCQDMQdg+DMSoofl907bAipwSHiLxvlG3KSdPam 0w+0jWC+VR0QOo6NYH3wOrzZm//gBeddZT1AadqdoBmsSEmkaOBxT5m5qaYN7YagjX4B td7FrkWPEdeY3jJUiWoTZSfocMVJKPXSTEG2cEQI+R8XWOqE9Rirwe2mzS6dC7AiChIC AX62cfxWIeD0fybXIC3J/k1penXFChou2/FQU59OrJL9XRgNXz8crEB1DAa0TUkzKclY 04b8CkzJk68j3xu6XXuk/1JPPC7wH3Wh6ywMqhloWPg5jbe4D4uW8+zykcKrenPm/52S VrQg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=zqkx5Wa7xZWMkMCn1hqymNWHmYh7PIZ+YscvAx/RdYE=; b=QGOUc5Cd7KfU1hCFaRwEHjgOXWtWzlvTlR0xSkERf95jvxEwLX9kQRnWjnXdM1kp7y HmOZ/4sE3buDq4OZpy5huxd4wsBkUdNyEeAWNkJeJEul2srjcWxFi0U2cNP/059495Vu opoI2Ytz604bzpd4jVm0AgrieXJYtRDhCkhIHJ7/vvh8SeXgWOv5JxlCeS0L3Boxc7AV ebqYDBYpYGd8h8P82yGyOesYPEqNUGxEhaX1cy9DNe7nbZHN5LH9TKEq9OantCtVgnSh IjPPMvPBN0/gEvw9f+oTDhGCcdpDrabac4/ljKRTDAcQR/6ojWLFhFr4ZIJy6meD3q5M f7zQ== X-Gm-Message-State: AOAM530/DAk5xsCm0F6xp6/qwOFE26rjA7tgb/x/HnDC9AXpCOu42ypF EXPIMWWg8Ve0C4Tlg+JwKumLihH1IP99IRUkxC1S4mBhJtE= X-Google-Smtp-Source: ABdhPJxNq/BdDhxNcZXcmXS+1FMvrlW96TGWH/iu57zT7D7hk4RfhRwSOchvABmzVkETiyMIj7CbiABvQaer4PLezBo= X-Received: by 2002:a05:6808:3d8:: with SMTP id o24mr13582775oie.168.1637830502308; Thu, 25 Nov 2021 00:55:02 -0800 (PST) MIME-Version: 1.0 References: <163765033620.23200.12862742917966078276@malur.postgresql.org> In-Reply-To: From: trn nrjn Date: Thu, 25 Nov 2021 14:24:51 +0530 Message-ID: Subject: Re: PostgreSQL XA resource manager for C/C++ apps To: davecramer@postgres.rocks Cc: pgsql-interfaces@lists.postgresql.org Content-Type: multipart/alternative; boundary="0000000000004ade9505d1992196" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000004ade9505d1992196 Content-Type: text/plain; charset="UTF-8" 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? 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 > > --0000000000004ade9505d1992196 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Thanks Dave. This seems to use ODBC whereas I am loo= king for XA support in PostgreSQL C/C++ client library itself, something si= milar to what Oracle provides in the OCI library. Can you please suggest if= there is one?

Thanks.

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


<= /div>
On Tue, 23 Nov 20= 21 at 02:10, trn nrjn <shuba14@gmail.com> wrote:
Hi,
Could you please assist with the following when n= ot using ODBC/JDBC?

1. Does PostgreSQL participate as an XA res= ource manager in an XA transaction managed by a transaction manager (eg: Or= acle Tuxedo) 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 resource manager by C/C++ applications managed by a a transaction manag= er (eg: Oracle 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 (simila= r to xaosw 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.post= gres.rocks

--0000000000004ade9505d1992196--