Re: commit inside plpgsql function

Already been answered (by me) -- you can't do this in postgres 7.x or earlier -- procedures may not have begins/commits or rollbacks. Version 8.0 *may* be different -- I don't have it installed yet; it does allow for some nesting of transactions but I don't know if this is allowed. The 8.0 documentation on user defined procedures would probably say.

Greg Williamson
DBA
GlobeXplorer LLC

-----Original Message-----
From: Dennis Sacks [mailto:dennis(at)illusions(dot)com]
Sent: Tue 12/21/2004 9:21 AM
To: pgsql-sql(at)postgresql(dot)org
Cc:
Subject: [SQL] commit inside plpgsql function
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

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match