SPI_ERROR_TRANSACTION [PostgreSQL 8.3]

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.