From: Scott Petersen <scottpetersen@softhome.net>
To: pgsql-sql@postgresql.org
Subject: Savepoint/Rollback in functions
Date: Tue, 14 Mar 2006 15:41:32 -0700
Message-ID: <4417469C.8020600@softhome.net> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: scottpetersen@softhome.net
Subject: Re: Savepoint/Rollback in functions
In-Reply-To: <4417469C.8020600@softhome.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox