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