Postgres Pro
Downloads
Home   >   mailing lists

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

From Thomas Kellerer
Subject Re: equivalent of @@TRANCOUNT PostgreSQL
Date
Msg-id 445011bb-b76d-9174-aebe-f6727944054d@gmx.net
Whole thread Raw
In response to equivalent of @@TRANCOUNT PostgreSQL  (<mustafa.pekgoz@forenda.com.tr>)
Responses Re: equivalent of @@TRANCOUNT PostgreSQL
List pgsql-admin
Tree view 
mustafa.pekgoz@forenda.com.tr schrieb am 29.05.2021 um 15:07:
> I have a procedure where they have used @@TRANCOUNT , is there an
> equivalent of @@TRANCOUNT in PostgreSQL? (Except Savepoint)
The equivalent in Postgres is

    SELECT 1

pgsql-admin by date:

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