Skip site navigation (1) Skip section navigation (2)

Re: locking

From: Jan Vicherek <honza(at)ied(dot)com>
To: pgsql-hackers(at)postgreSQL(dot)org
Cc: pgsql-questions(at)postgreSQL(dot)org
Subject: Re: locking
Date: 1998-01-21 04:19:48
Message-ID: Pine.LNX.3.96.980120231609.2939D-100000@ann.ied.com (view raw or flat)
Thread:
Lists: pgsql-hackers
  *Any* answers would be appreciated :

 I'll rephrase the original questions :

pg doesn't have "row-level locking" but has "table locking".
a result from a SELECT * FROM TESTTABLE; is a table.
I lock the table (which is result of a SELECT).

 Q : will this locking prevent update of the rows in TESTTABLE that have
been SELECTed ?

     Thanx,

          Jan

On Mon, 19 Jan 1998, Jan Vicherek wrote:

>    I'm trying to figgure out how does the locking work.
> 
>   If I get a ``Result Table'' from a select with, say, only one row which
> comes from only one ``Schema Table'', and I lock the ``Result Table'',
> will it not prevent updates of the row in ``Schema Table'' that appeared 
> in the ``Result Table'' ? 

 -- Gospel of Jesus is the saving power of God for all who believe --
Jan Vicherek ## To some, nothing is impossible. ##  www.ied.com/~honza
    >>>    Free Software Union President  ...  www.fslu.org    <<<
Interactive Electronic Design Inc.    -#-    PGP: finger honza(at)ied(dot)com


In response to

  • locking at 1998-01-19 22:40:33 from Jan Vicherek

Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 1998-01-21 04:21:22
Subject: subselects
Previous:From: Bruce MomjianDate: 1998-01-21 03:24:11
Subject: subselects

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group