Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.1) with SMTP id f5KGVra87102 for ; Wed, 20 Jun 2001 12:31:53 -0400 (EDT) (envelope-from pgsql-admin-owner@postgresql.org) Received: from fslc.ser.usu.edu (fslc.ser.usu.edu [129.123.28.122]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5KElVa35029; Wed, 20 Jun 2001 10:47:31 -0400 (EDT) (envelope-from rmello@fslc.usu.edu) Received: (from rmello@localhost) by fslc.ser.usu.edu (8.12.0.Beta5/8.12.0.Beta5/Debian 8.12.0-1) id f5KElLiV006866; Wed, 20 Jun 2001 08:47:21 -0600 Date: Wed, 20 Jun 2001 08:47:21 -0600 From: Roberto Mello To: Christof Glaser Cc: Mahesh Guleria , pgsql-sql@postgresql.org, pgsql-admin@postgresql.org Subject: Re: [SQL] Re: Row Level Locking !! Message-ID: <20010620084721.A6835@cc.usu.edu> References: <01062013035000.00721@pinguin> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <01062013035000.00721@pinguin> User-Agent: Mutt/1.3.18i X-Archive-Number: 200106/131 X-Sequence-Number: 1697 On Wed, Jun 20, 2001 at 01:03:49PM +0200, Christof Glaser wrote: > 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. I'd like to point out (for the new users around) that PostgreSQL has had Multi Version Concurrency Control for quite some time. You don't have to do anything special to use it. It's the default to handle concurrency. -Roberto -- +----| http://fslc.usu.edu USU Free Software & GNU/Linux Club |------+ Roberto Mello - Computer Science, USU - http://www.brasileiro.net http://www.sdl.usu.edu - Space Dynamics Lab, Developer * * * <- Tribbles . . . <- Tribbles after a haircut