Re: Is function atomic? - Mailing list pgsql-sql

From Peter Eisentraut
Subject Re: Is function atomic?
Date
Msg-id Pine.LNX.4.30.0107061924190.679-100000@peter.localdomain
Whole thread Raw
In response to Re: Is function atomic?  (Wei Weng <wweng@kencast.com>)
List pgsql-sql
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@gmx.net   http://funkturm.homeip.net/~peter



pgsql-sql by date:

Previous
From: Wei Weng
Date:
Subject: Re: Is function atomic?
Next
From: Wei Weng
Date:
Subject: view and performance