From: Tom Lane <tgl@sss.pgh.pa.us>
To: MichaelDBA <MichaelDBA@sqlexec.com>
cc: "David G. Johnston" <david.g.johnston@gmail.com>,
        "dave@davebolt.co.uk" <dave@davebolt.co.uk>,
        Julien Rouhaud <rjuju123@gmail.com>,
        "mustafa.pekgoz@forenda.com.tr" <mustafa.pekgoz@forenda.com.tr>,
        Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: equivalent of @@TRANCOUNT PostgreSQL
In-reply-to: <43af0a07-99df-6125-4227-ce1c22bd1fb8@sqlexec.com>
References: <004101d7548b$894e0ce0$9bea26a0$@forenda.com.tr>
 <CAOBaU_bwoQ8Hos1rrMHmGyzA5TfP0oJ0J3tHGYabod_Pe6YwHw@mail.gmail.com>
 <042901d75497$c2da72d0$488f5870$@co.uk>
 <CAKFQuwZZDB5bSYK+MzEvbdGCCSeLrG+eC5UC4NraVLmw=iEkaQ@mail.gmail.com>
 <43af0a07-99df-6125-4227-ce1c22bd1fb8@sqlexec.com>
Comments: In-reply-to MichaelDBA <MichaelDBA@sqlexec.com>
	message dated "Sat, 29 May 2021 10:50:24 -0400"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <2045692.1622300470.1@sss.pgh.pa.us>
Date: Sat, 29 May 2021 11:01:10 -0400
Message-ID: <2045693.1622300470@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/2045693.1622300470%40sss.pgh.pa.us>
Precedence: bulk

MichaelDBA <MichaelDBA@sqlexec.com> writes:
> I don't think so, it's not current active transactions, but number of 
> active transactions on the CURRENT CONNECTION.

Isn't that a constant 1?  We don't do multiple active transactions
in one session.

			regards, tom lane