commit in plpgsql function?

From: Dennis Sacks <dennis(at)illusions(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: commit in plpgsql function?
Date: 2004-12-21 17:34:02
Message-ID: 41C85E8A.20906@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 Gregory S. Williamson 2004-12-21 21:08:20 Re: commit in plpgsql function?
Previous Message Dennis Sacks 2004-12-21 17:21:51 commit inside plpgsql function