Re: @@TRANCOUNT ?

Поиск
Список
Период
Сортировка
От Justin
Тема Re: @@TRANCOUNT ?
Дата
Msg-id CALL-XeP8=rniSsmNAC7jLF26MRM2j9oKBvgJxwkPcKeS90JWfQ@mail.gmail.com
обсуждение исходный текст
Ответ на @@TRANCOUNT ?  (İlyas Derse <ilyasderse@gmail.com>)
Список pgsql-general
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Rob Sargent
Дата:
Сообщение: Re: @@TRANCOUNT ?
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: SQL Query Syntax help