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
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
