Re: Is function atomic?

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: Is function atomic?
Дата
Msg-id Pine.LNX.4.30.0107061924190.679-100000@peter.localdomain
обсуждение исходный текст
Ответ на Re: Is function atomic?  (Wei Weng <wweng@kencast.com>)
Список 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 по дате отправления:

Предыдущее
От: Wei Weng
Дата:
Сообщение: Re: Is function atomic?
Следующее
От: Wei Weng
Дата:
Сообщение: view and performance