Re: Is function atomic?

Wei Weng writes:

> What I wanted is simple:
> I don't want other processes that run the function at the same time have
> read/write access from the tables this function accesses(select and
> insert/update). Is it possible, say, let other proccess blocked on this
> function?

See LOCK command. But note that this would lock out process in this
function or any other access to these tables. Maybe you should take a
look at the userlock module in contrib.

--
Peter Eisentraut peter_e(at)gmx(dot)net http://funkturm.homeip.net/~peter