SELECT FOR SHARE and FOR UPDATE

From: "Ilja Golshtein" <ilejn(at)yandex(dot)ru>
To: pgsql-general(at)postgresql(dot)org
Subject: SELECT FOR SHARE and FOR UPDATE
Date: 2005-10-07 09:18:03
Message-ID: 43463D4B.000006.09053@pantene.yandex.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2005-10-07 09:36:27 Re: Shell script to extract a table from a plain text dump
Previous Message Hannes Dorbath 2005-10-07 09:17:43 Re: copy data between database