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:
В списке pgsql-general по дате отправления: