Re: row locking question

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Darren Govoni <darren(at)ontrenet(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: row locking question
Date: 2008-11-18 00:37:24
Message-ID: 9449.1226968644@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Darren Govoni <darren(at)ontrenet(dot)com> writes:
> For example, there is a table with many rows. Threads are doing
> "SELECTS" to read some rows. They should be allowed to get results on
> rows that are not currently locked by another thread's SELECT,FOR UPDATE
> or equivalent read lock for those rows only.

Make those threads use SELECT FOR SHARE.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Hiroshi Saito 2008-11-18 00:50:04 Re: Trying Compile libpq.dll with VC++ 9.0, but need help
Previous Message Darren Govoni 2008-11-18 00:29:35 row locking question