commit inside plpgsql function

From: Dennis Sacks <dennis(at)illusions(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: commit inside plpgsql function
Date: 2004-12-21 17:21:51
Message-ID: 41C85BAF.6000305@illusions.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-sql by date

  From Date Subject
Next Message Dennis Sacks 2004-12-21 17:34:02 commit in plpgsql function?
Previous Message Richard Huxton 2004-12-21 11:16:44 Re: linux clusters and pgsql