Re: pl/pgSQL & transaction - Mailing list pgsql-interfaces

From Tibor Laszlo
Subject Re: pl/pgSQL & transaction
Date
Msg-id 01011911292000.01181@tir
Whole thread Raw
In response to pl/pgSQL & transaction  ("Zolof" <zolof@club-internet.fr>)
Responses Re: pl/pgSQL & transaction
List pgsql-interfaces
> This code doesn't work. I use Begin Work to start a transaction but BEGIN is
> a PL/pgSQL command so I have a parse error when executing it.
> 
> CREATE FUNCTION a () RETURNS int4 AS '
> BEGIN
>    BEGIN WORK;
>    COMMIT WORK;
>     return 1;
>     END;
> ' LANGUAGE 'plpgsql';
> 
> What's wrong ????

Is it possible to use transactions in PL/pgSQL functions? AFAIK these functions
always(?) in a transaction (eg as triggers or as stored pprocs) and PostgreSQL
doesn't support nested transactions.

-- 
Tibor Laszlo
ltibor@mail.tiszanet.hu


pgsql-interfaces by date:

Previous
From: Peter T Mount
Date:
Subject: Re: [PATCHES] Re: Fixes and enhancements to JDBC driver (take 2)
Next
From: Mindaugas Idzelis
Date:
Subject: bug in ODBC driver (and fix)