Received: from gl.aser.de (gl.aser.de [213.252.128.30]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5KB2fa35594; Wed, 20 Jun 2001 07:02:41 -0400 (EDT) (envelope-from gcg@gl.aser.de) Received: from pinguin.gl.aser.de (pec-86-118.tnt5.b2.uunet.de [149.225.86.118]) by gl.aser.de (Postfix) with ESMTP id 1E8B421DE3; Wed, 20 Jun 2001 13:15:21 +0200 (MEST) Received: from pinguin (pinguin.gl.aser.de [192.168.1.111]) by pinguin.gl.aser.de (Postfix) with SMTP id 47E0113102; Wed, 20 Jun 2001 13:03:50 +0200 (CEST) Content-Type: text/plain; charset="iso-8859-1" From: Christof Glaser Organization: gl.aser software engineering . internet service To: "Mahesh Guleria" , , Subject: Re: Row Level Locking !! Date: Wed, 20 Jun 2001 13:03:49 +0200 X-Mailer: KMail [version 1.2] References: In-Reply-To: MIME-Version: 1.0 Message-Id: <01062013035000.00721@pinguin> Content-Transfer-Encoding: 8bit X-Archive-Number: 200106/120 X-Sequence-Number: 1677 On Wednesday, 20. June 2001 07:46, Mahesh Guleria wrote: > Is it possible that we can use row level locking in postgres. > If "yes", > then but is the proceedure and where i can found the documentation. There is "something better than row level locking" called MVCC, or Multi Version Concurrency Control for short. See Chapter 9 of the User Guide: http://www.postgresql.org/idocs/index.php?mvcc.html Hope that helps, Christof -- gl.aser . software engineering . internet service http://gl.aser.de/ . Planckstraße 7 . D-39104 Magdeburg