commit inside plpgsql function - Mailing list pgsql-sql

From Dennis Sacks
Subject commit inside plpgsql function
Date
Msg-id 41C85BAF.6000305@illusions.com
Whole thread Raw
List pgsql-sql
Hi,

I am converting oracle stored procedures to plpgsql. There are several 
of the oracle procedures where a parameter vCommit is passed into the 
procedure and:

if vCommit = 1   then       commit;       do_something_commit(vdate);   else       do_something(vdate);   end if;

does this make sense in plpgsql? Does it make sense to do a commit in 
plpgsql?

Thanks,

Dennis


pgsql-sql by date:

Previous
From: "Iain"
Date:
Subject: Re: I'm stumped
Next
From: "william lim"
Date:
Subject: save sql result to file