X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 8D753D1D202 for ; Tue, 17 Feb 2004 13:02:55 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 38186-05 for ; Tue, 17 Feb 2004 09:02:56 -0400 (AST) Received: from internet.potentialtech.com (h-66-167-251-6.PHLAPAFG.covad.net [66.167.251.6]) by svr1.postgresql.org (Postfix) with ESMTP id EF622D1CB1D for ; Tue, 17 Feb 2004 09:02:52 -0400 (AST) Received: from potentialtech.com (pa-plum1c-102.pit.adelphia.net [24.53.179.102]) by internet.potentialtech.com (Postfix) with ESMTP id B3E3F69A71; Tue, 17 Feb 2004 08:02:54 -0500 (EST) Message-ID: <403210FB.5040209@potentialtech.com> Date: Tue, 17 Feb 2004 08:02:51 -0500 From: Bill Moran User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.4) Gecko/20031005 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Christopher Kings-Lynne Cc: Saleem Burhani Baloch , pgsql-performance@postgresql.org Subject: Re: Slow response of PostgreSQL References: <200402170624.i1H6O2u16022@ns2.khi.wol.net.pk> <4031BBBC.5050002@familyhealth.com.au> In-Reply-To: <4031BBBC.5050002@familyhealth.com.au> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/184 X-Sequence-Number: 5708 Christopher Kings-Lynne wrote: >> 1- How can I lock a single record so that other users can only read >> it. ?? > > You cannot do that in PostgreSQL. How about SELECT ... FOR UPDATE? -- Bill Moran Potential Technologies http://www.potentialtech.com