SPI_ERROR_TRANSACTION [PostgreSQL 8.3]

[Daroslav <daroslav@xxxx>]

Hi

As a newbie in PL/pgSQL I have faced an error SPI_ERROR_TRANSACTION which
was raised always when I have tried to launch following function with
uncommented keywords SAVEPOINT, SET TRANSACTION and COMMIT(when commented,
function works fine): 

CREATE OR REPLACE FUNCTION insert_employee(
name_emp varchar, surname_emp varchar, street_emp varchar, postcode_emp
varchar, city_emp varchar, login_emp varchar, password_emp varchar)
returns boolean as $insert_emp$

DECLARE
	last_row_id integer;
	
BEGIN

	--SAVEPOINT my_savepoint;
	--SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;
	INSERT INTO person VALUES (nextval('person_seq'), $1,$2,$3,$4,$5);
	IF NOT FOUND THEN
		ROLLBACK TO SAVEPOINT my_savepoint;
		RAISE EXCEPTION 'New person insertion error';
		RETURN false;
	END IF;
	
	SELECT currval('public.person_seq') INTO last_row_id;
	
	INSERT INTO employee VALUES (nextval('employee_seq'), last_row_id, $6, $7);
	IF NOT FOUND THEN
		ROLLBACK TO SAVEPOINT my_savepoint;
		RETURN false;
	END IF;
	--COMMIT;
	
	RETURN true;

END;
$insert_emp$ LANGUAGE plpgsql;

I don't know why these keywords cannot be used in function block if they
works fine in Begin-Commit block. How can I change TRANSACTION type into
SERIALIZABLE within mentioned insert_employee function. 

Thanks in advance,
Daroslav

-- 
View this message in context: http://www.nabble.com/SPI_ERROR_TRANSACTION--PostgreSQL-8.3--tp23277399p23277399.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general