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 [EMAIL PROTECTED] http://funkturm.homeip.net/~peter
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html