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 <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1ln3V6-0006R7-GR
	for pgsql-admin@arkaria.postgresql.org; Sat, 29 May 2021 18:15:56 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1ln3V4-0007ln-OG
	for pgsql-admin@arkaria.postgresql.org; Sat, 29 May 2021 18:15:54 +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 <shammat@gmx.net>)
	id 1ln3V4-0007lf-ER
	for pgsql-admin@lists.postgresql.org; Sat, 29 May 2021 18:15:54 +0000
Received: from mout.gmx.net ([212.227.17.22])
	by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <shammat@gmx.net>)
	id 1ln3V0-0001LK-E4
	for pgsql-admin@lists.postgresql.org; Sat, 29 May 2021 18:15:53 +0000
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=gmx.net;
	s=badeba3b8450; t=1622312147;
	bh=XJKcmwhDUGO7q2rtgZwlEaAb7HZ91jYx/dSloowcrYA=;
	h=X-UI-Sender-Class:Subject:To:References:From:Date:In-Reply-To;
	b=J3GCoOnZ/St4bvqixqwCGYg990AJEgcVALpebqKtvZthVEtVE73Yx/5JYF194JvhI
	 oCYC3nBkPKnWEVoFe8cC8gPPvRL/uD9GfQMv7nDHEAdOPQhWC2ljgSfGb345N3PF7K
	 RmwU8FtnjrBX5oUWXYh01xLMHW1+1oe/8mow42w8=
X-UI-Sender-Class: 01bb95c1-4bf8-414a-932a-4f6e2808ef9c
Received: from [192.168.178.20] ([83.171.162.62]) by mail.gmx.net (mrgmx104
 [212.227.17.168]) with ESMTPSA (Nemesis) id 1MUGiJ-1lvgbB3WfD-00RDzy for
 <pgsql-admin@lists.postgresql.org>; Sat, 29 May 2021 20:15:46 +0200
Subject: Re: equivalent of @@TRANCOUNT PostgreSQL
To: pgsql-admin@lists.postgresql.org
References: <004101d7548b$894e0ce0$9bea26a0$@forenda.com.tr>
From: Thomas Kellerer <shammat@gmx.net>
Message-ID: <445011bb-b76d-9174-aebe-f6727944054d@gmx.net>
Date: Sat, 29 May 2021 20:15:44 +0200
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.8.1.21)
 Gecko/20090302 Thunderbird/2.0.0.21 Mnenhy/0.7.5.666
MIME-Version: 1.0
In-Reply-To: <004101d7548b$894e0ce0$9bea26a0$@forenda.com.tr>
Content-Type: text/plain; charset=windows-1254; format=flowed
Content-Language: de-DE
Content-Transfer-Encoding: 7bit
X-Provags-ID: V03:K1:Eszs4bTrMhX+0EFeZ3em6W0C58Anx4R7DevvwOEXmI6tS3/fveD
 /YkluIB17UYfaqKOkMzP78kxdL3WdPEOQqIKrHMiFusKn3orqFQqOsIXG+RIvRNV4cLuAL3
 WI3qP0vhs1VKIf5M9RV+o2HMWVYxa/3F1CrF8c8QFdFEekmxuDhOgbEYIakojPei+K9Vx2r
 C5opE00oOZyLvREJZgp5w==
X-Spam-Flag: NO
X-UI-Out-Filterresults: notjunk:1;V03:K0:OMSP+mw91Fo=:zbV3uAO8SassmwHHwdspCq
 z3/0aA0ehzMYDDjJYRYSjhEFpXi/bk38yCHCQZpYdqCsY8vISPNNxVW9+Ev+a8BTcgd3SgfO8
 jX/+b/n/SpVGNuv6qHbGjr+jYnF5Wx58KkR/ZVNj7xKsuKfZ0WnrDAeduGo9bKR7JYmLf0Zn/
 zmM74vqOzfMWUrOtvcOEdvfgWUILohputGGn+8r1lzs1o4jEoBGw/StsDuCmxrduy1vxS23sT
 WVNMRF2rlVCxjWZmOkgOlm2niuuZddNl0hmJzeUyesbjVbp44Xqri4NriEMGqAI1xq/nR06Ig
 8SpNcBGi8MU3lM5DQ0eZrHwuhlbq6cO5h/2NX0uxglG7EEx3EopvlA3Lgc+INis4cY396+rts
 ppxnlWeOVD28a7VLMU6pwaelnVtU3HPodLQk+TQ+SYMegItUX/EgQiq4SNcme8z2MNETrmUqN
 SNKzTq6HqEjnI6Nkq7MBKSisq7XMMj1rnAAxMF0UQvaKzSOxJXw9CAqo44+eTdkSc1afcEo3K
 +n8wRN/+yM+BNWEqk0JainNCBU/ubYY4mNjTI23o46AnXrhcGVCoKB4gDnbU9Gli8FoeVM/PC
 7FYDuXz/S68JiVToVLxkPRRJ/I0PsLLZY6utOtUX4Hl5uHmEe0868lsbDaWTd4ysB5QEHwlV+
 EdJTZWHQ0aO3blxAi44OHTwtQUd1tnWvPdxXpKbiNUPqdFTHfymQTzNN+h7ngzyeof2krDAHa
 fgCEmvaXqfztcpL7ivdl8xVZGqfqXoQuG84YprE02LB7xGGbOI8z8lvVoQonCfgrJ3rEZRxzW
 bIRK/ui9msCubD5I5efdCTfKyB4qGYBbwdpKgxl15cYl4VGFmCqd0gUV7+sNU7a0hNiYTat3g
 Aewq9rM8JctbU4/LIE0r9xbXJLgFyp0yVCG510vFrMc6Fc2OksTb6ZAt17ip6aJ3CjCgKIsJc
 +0GwaazLexDK6Y7CRu8eHWhl6vsOIxq/KMVXxstC3LPtm4dK6lfeBEamJpZbqzaeQZyXbm2ID
 +fB8FQSMYzJ1aO1Zt2W1axaNTlulV10RoqbApuiAwnW/ZMrshkfieOo9JhFNOsTuU+Ic+mqBI
 qOuI9JcapqTuMf34DCHcFXC1guVcdjcAocJqt4JJO16dLoDpWhD6B9NPTc7CHjrKe2X54zH6d
 BqC4OIhdYIbWjWnVPdlAr0d2DmvDmh+NRM1Dnc9xkyknfDe9kHPa+nQD33lRm5LIf6HRc=
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/445011bb-b76d-9174-aebe-f6727944054d%40gmx.net>
Precedence: bulk

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