Savepoint/Rollback in functions

From: Scott Petersen <scottpetersen(at)softhome(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: Savepoint/Rollback in functions
Date: 2006-03-14 22:41:32
Message-ID: 4417469C.8020600@softhome.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I am running postgres 8.1.2 on both a windows and Linux platform.

The primary method of managing business logic is through the use of
functions. Our primary access to the database is by using PSQL (pg/psql).

The problem that I am having is that we need to execute and implement
"SAVEPOINT" and "ROLLBACK" functionality inside of FUNCTIONS. The
"SAAVEPOINT/ROLLBACK" works fine interactively. At the present time the
documentation does not seem to be definitive on the functionality of
this, BUT, we placed "SAVEPOINT/ROLLBACK" commands in a test function
and the function failed.

Question 1: does pg/psql functions allow "SAVEPOINT/ROLLBACK"
functionality? (if so how?)

Question 2: if the answer to question 1 is "NO", what would be required
to get this implemented in the standard product?

Thanks in advance for any information and help.

Scott.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Alvaro Herrera 2006-03-14 23:11:18 Re: Savepoint/Rollback in functions
Previous Message Andreas Kretschmer 2006-03-14 20:54:27 Re: how to get the size of array?