>>> 1- How can I lock a single record so that other users can only read
>>> it. ??
>> You cannot do that in PostgreSQL.
> How about SELECT ... FOR UPDATE?
No, because users cannot read the locked row in that case.
In response to
pgsql-performance by date
|Next:||From: scott.marlowe||Date: 2004-02-18 01:50:08|
|Subject: Re: Slow response of PostgreSQL|
|Previous:||From: Tom Lane||Date: 2004-02-17 23:55:42|
|Subject: Re: long running query running too long |