Request a Demo
Home   >   mailing lists

SELECT FOR SHARE and FOR UPDATE - Mailing list pgsql-general

From Ilja Golshtein
Subject SELECT FOR SHARE and FOR UPDATE
Date
Msg-id 43463D4B.000006.09053@pantene.yandex.ru
Whole thread Raw
Responses Re: SELECT FOR SHARE and FOR UPDATE
List pgsql-general
Tree view 
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 by date:

Previous
From: Hannes Dorbath
Date:
Subject: Re: copy data between database
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Shell script to extract a table from a plain text dump