Transaction with in function - Mailing list pgsql-general

From Ravi Katkar
Subject Transaction with in function
Date
Msg-id 46AC8D44F3AE1F4888F137837D0DF635072561999D@INHYWEXMB2.infor.com
Whole thread Raw
Responses Re: Transaction with in function  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
handling out parameter  (Ravi Katkar <Ravi.Katkar@infor.com>)
Do ODBC - Posgresql supports refcursor?  (Ravi Katkar <Ravi.Katkar@infor.com>)
List pgsql-general

 

I looking for solution for commit, rollback with in function.

 

Below is Example function

 

 

CREATE OR REPLACE FUNCTION test()

  RETURNS void AS

$BODY$

BEGIN

--- set    of statements

 

Commit;

 

-- set of statement

commit;

 

-- if things goes wrong

rollback

 

   

RETURN;

END; $BODY$

  LANGUAGE 'plpgsql';

 

 

Thanks in advance .

 

Regards

Ravi Katkar

 

 

 

 

pgsql-general by date:

Previous
From: Mark Wong
Date:
Subject: Fwd: PDXPUG Day at OSCON 2010
Next
From: "A. Kretschmer"
Date:
Subject: Re: Transaction with in function