Received: from smtp-relay.noc.dsvr.net (smtp-relay.noc.dsvr.net [212.69.192.4]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g1IKkFE34537 for ; Mon, 18 Feb 2002 15:46:15 -0500 (EST) (envelope-from me@shanewright.co.uk) Received: from [212.69.206.2] (helo=fullerruss.dsvr.co.uk) by smtp-relay.noc.dsvr.net with esmtp (Exim 3.16 #1) id 16cqnW-000I48-00; Mon, 18 Feb 2002 16:37:50 +0000 Received: from there (host213-122-70-220.in-addr.btopenworld.com [213.122.70.220] (may be forged)) by fullerruss.dsvr.co.uk (8.11.3/8.11.1) with SMTP id g1IGbfJ04987; Mon, 18 Feb 2002 16:37:46 GMT Message-Id: <200202181637.g1IGbfJ04987@fullerruss.dsvr.co.uk> Content-Type: text/plain; charset="iso-8859-1" From: Shane Wright Reply-To: me@shanewright.co.uk To: Tom Lane Subject: Re: table locking Date: Mon, 18 Feb 2002 16:37:38 +0000 X-Mailer: KMail [version 1.3.2] Cc: pgsql-sql@postgresql.org References: <200202181516.g1IFGF517803@candle.pha.pa.us> <200202181521.g1IFLwk24097@fullerruss.dsvr.co.uk> <11225.1014046976@sss.pgh.pa.us> In-Reply-To: <11225.1014046976@sss.pgh.pa.us> MIME-Version: 1.0 Content-Transfer-Encoding: 8bit X-Archive-Number: 200202/222 X-Sequence-Number: 6646 Hi Tom, Sorry I tihnk I misunderstood your post the first time round :( SHARE ROW EXCLUSIVE MODE works just fine :)) Thanks very much :) Regards Shane On Monday 18 Feb 2002 3:42 pm, Tom Lane wrote: > I think you want just LOCK TABLE tab IN SHARE ROW EXCLUSIVE MODE > or LOCK TABLE tab IN EXCLUSIVE MODE. The latter would lock out > SELECT FOR UPDATE, the former wouldn't. > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly