commit in plpgsql function? - Mailing list pgsql-sql

From Dennis Sacks
Subject commit in plpgsql function?
Date
Msg-id 41C85E8A.20906@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: Richard Huxton
Date:
Subject: Re: linux clusters and pgsql
Next
From: "Gregory S. Williamson"
Date:
Subject: Re: commit in plpgsql function?