Re: autocommit for multi call store procedure

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: autocommit for multi call store procedure
Дата
Msg-id ea6b7f85-2fc0-e999-3ccc-ca5b17c5169b@aklaver.com
обсуждение исходный текст
Ответ на autocommit for multi call store procedure  (Trang Le <trang.le@evizi.com>)
Список pgsql-general
On 9/16/21 12:36 AM, Trang Le wrote:
> Hi guys,
> 
> I am using pgadmin4 to interact with Postgres database. For now I would 
> like to run 2 store procedure (those have commit statement in begin end 
> block). I enable autocommit and run call 2 store procedures at the same 
> time. However, there is an error with invalid transaction termination.
> 
> Could you help me on this issue?

Maybe but will need to see:

1) The content of the procedures.

2) The manner in which they are called.

3) The actual complete error message.

> 
> Thanks,
> Trang


-- 
Adrian Klaver
adrian.klaver@aklaver.com



В списке pgsql-general по дате отправления:

Предыдущее
От: Edson Carlos Ericksson Richter
Дата:
Сообщение: Re: The tragedy of SQL
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: The tragedy of SQL