Daroslav wrote: > > 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):
Yes, you cannot use those constructs in plpgsql (or any other PL for that matter; it's a limitation of the underlying layer). You need to use BEGIN/EXCEPTION/END blocks instead. Also, keep in mind that if you RAISE EXCEPTION, the current transaction is always rolled back, so the RETURN FALSE in your function would never be reached. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
