| From: | "Nykolyn, Andrew" <andrew(dot)nykolyn(at)ngc(dot)com> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Nested Transactions in PL/pgSQL |
| Date: | 2007-07-05 17:34:09 |
| Message-ID: | F45D63E8C730D04F899B1227D5D03FD81C0C52@XMBIL101.northgrum.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kenji Morishige | 2007-07-05 17:39:31 | simple query question to use with DBI selectall_hashref |
| Previous Message | Andrew Sullivan | 2007-07-05 17:20:44 | Re: [pgsql-general] In memory tables/databases |