Postgres Pro
Downloads
Home   >   mailing lists

Thread: @@TRANCOUNT ?

@@TRANCOUNT ?

From
İlyas Derse
Date:
What's Prostgres' equivalent of select @@trancount?  Do you have an idea ?

Re: @@TRANCOUNT ?

From
Rob Sargent
Date:
1 ;)

On Jan 22, 2020, at 5:59 AM, İlyas Derse <ilyasderse@gmail.com> wrote:


What's Prostgres' equivalent of select @@trancount?  Do you have an idea ?

Re: @@TRANCOUNT ?

From
Justin
Date:
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 ?