SELECT FOR SHARE and FOR UPDATE

Поиск
Список
Период
Сортировка
От Ilja Golshtein
Тема SELECT FOR SHARE and FOR UPDATE
Дата
Msg-id 43463D4B.000006.09053@pantene.yandex.ru
обсуждение исходный текст
Ответы Re: SELECT FOR SHARE and FOR UPDATE
Список pgsql-general
Hello!

I want to select data from two tables obtaining
exclusive lock for records of the first table and
nonexclusive lock for records of the second one.

In other words, I need something like
select a.f, b.f from a,b for update of a for share of b.
Any hints?

Thanks.

--
Best regards
Ilja Golshtein

В списке pgsql-general по дате отправления: