Postgres Pro
Downloads
Home   >   mailing lists

Re: @@TRANCOUNT ? - Mailing list pgsql-general

From Justin
Subject Re: @@TRANCOUNT ?
Date
Msg-id CALL-XeP8=rniSsmNAC7jLF26MRM2j9oKBvgJxwkPcKeS90JWfQ@mail.gmail.com
Whole thread Raw
In response to @@TRANCOUNT ?  (İlyas Derse <ilyasderse@gmail.com>)
List pgsql-general
Tree view
Postgresql does not support Transaction in the same way mssql,   it  does support nesting transactions in a limited way from version 11+


From version 11 and up we have Procedures  it supports commit and rollback transaction inside a PROCEDURE and must be called with CALL,  there are no savepoints or transaction naming support...

There are work around this problem using PlPython, or FDW to callback to postgresql creating a new session to create independent Transactions..
 






On Wed, Jan 22, 2020 at 7:59 AM İlyas Derse <ilyasderse@gmail.com> wrote:
What's Prostgres' equivalent of select @@trancount?  Do you have an idea ?

pgsql-general by date:

Previous
From: Rob Sargent
Date:
Subject: Re: @@TRANCOUNT ?
Next
From: "David G. Johnston"
Date:
Subject: Re: SQL Query Syntax help