*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 ?
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
pgsql-hackers by date
|Next:||From: Bruce Momjian||Date: 1998-01-21 04:21:22|
|Previous:||From: Bruce Momjian||Date: 1998-01-21 03:24:11|