Thank you for the suggestion.
It seems that still blocks. Here is what I'm trying to achieve.
I have 10 rows each with an id 1,2,3,4 etc.
In one thread I want to update rows with id < 4 (1-3) in my_table
inside a transaction (i.e. begin work; update where; commit work;)
In another thread I do
Darren Govoni <[EMAIL PROTECTED]> 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 onl
Hi,
I have experimented with PostgreSQL's table locking and FOR UPDATE
capabilities. But what I'm looking for is a row level lock specific to
only a set of rows, not the entire table.
For example, there is a table with many rows. Threads are doing
"SELECTS" to read some rows. They should be allo
