Re: [SQL] Re: Row Level Locking !!

From: Roberto Mello <rmello(at)cc(dot)usu(dot)edu>
To: Christof Glaser <gcg(at)gl(dot)aser(dot)de>
Cc: Mahesh Guleria <mahesh(at)himline(dot)com>, pgsql-sql(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org
Subject: Re: [SQL] Re: Row Level Locking !!
Date: 2001-06-20 14:47:21
Message-ID: 20010620084721.A6835@cc.usu.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-sql

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Peter Eisentraut 2001-06-20 14:50:02 Re: SSL problem
Previous Message Shaun Thomas 2001-06-20 13:18:48 Notice logging.

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2001-06-20 14:51:26 Re: unrecognized language 'plpgsql'
Previous Message Bruno Boettcher 2001-06-20 14:46:36 possible to lock a single row in table?