Message-ID: <4417469C.8020600@softhome.net>
Date: Tue, 14 Mar 2006 15:41:32 -0700
From: Scott Petersen <scottpetersen@softhome.net>
User-Agent: Thunderbird 1.5 (Windows/20051201)
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: Savepoint/Rollback in functions
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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.