Postgres Pro
Downloads
Home   >   mailing lists

Re: equivalent of @@TRANCOUNT PostgreSQL - Mailing list pgsql-admin

From Tom Lane
Subject Re: equivalent of @@TRANCOUNT PostgreSQL
Date
Msg-id 2045693.1622300470@sss.pgh.pa.us
Whole thread Raw
In response to Re: equivalent of @@TRANCOUNT PostgreSQL  (MichaelDBA <MichaelDBA@sqlexec.com>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: equivalent of @@TRANCOUNT PostgreSQL
Next
From: Bruce Momjian
Date:
Subject: Re: equivalent of @@TRANCOUNT PostgreSQL