On Fri, Oct 07, 2005 at 01:18:03PM +0400, Ilja Golshtein wrote: > 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. >From http://www.postgresql.org/docs/8.0/interactive/sql-select.html: FOR UPDATE [ OF table_name [, ...] ] I'm assuming that the syntax is the same for FOR SHARE. -- Jim C. Nasby, Sr. Engineering Consultant jnasby@xxxxxxxxxxxxx Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
