[SQL] "no wait" in locks

Hi... anyone knows a workaround for Oracle "no wait" Option in "SELECT ... FOR UPDATE"? I wrote a programm which runs twice. Both poll the pgsql database all 5 seconds and make an "SELECT ... FOR UPDATE" for the first row found. After some work and commit the next row is processed. The second t

[SQL] "no wait" in locks

Hi... anyone knows a workaround for Oracle "no wait" Option in "SELECT ... FOR UPDATE"? I wrote a programm which runs twice. Both poll the pgsql database all 5 seconds and make an "SELECT ... FOR UPDATE" for the first row found. After some work and commit the next row is processed. The second t

[SQL] "no wait" option for locks

Hi... anyone knows a workaround for Oracles "no wait" option in "SELECT ... FOR UPDATE"? I wrote a programm which runs twice. Both poll the pgsql database all 5 seconds and make an "SELECT ... FOR UPDATE" for the first row found. After some work and commit the next row is processed. The second