Nested Transactions in PL/pgSQL
| От | Nykolyn, Andrew |
|---|---|
| Тема | Nested Transactions in PL/pgSQL |
| Дата | |
| Msg-id | F45D63E8C730D04F899B1227D5D03FD81C0C52@XMBIL101.northgrum.com обсуждение исходный текст |
| Ответы |
Re: Nested Transactions in PL/pgSQL
|
| Список | pgsql-general |
Is it possible to nest transactions within a stored procedure? I have a stored procedure that calls many other stored procedures and what happens it that after a certain amount of time the server runs out of shared memory. I know I can increase the PostgreSQL shared memory. However, that would be a temporary fix. I know it will eventually run out again as more data is processed. The right way to do it is to do issue a save point or commit at various places in my long stored procedure. I want to believe that there is a way to issue commits within a stored procedure since PostgreSQL now supports nested transactions.
Any help or work around would be appreciated. Thanks.
Andy Nykolyn
Northrop Grumman
В списке pgsql-general по дате отправления: