Tag Info

New answers tagged

0

As I dug deeper into the matter at hand trying various approaches I found out that there is no solution to this problem with PostgreSQL versions <= 9.4. PostgreSQL 9.5 (current development version) has a new feature called SKIP LOCKED which does skip rows that have been locked by a query using SELECT * ... FOR UPDATE For more information on the new ...


0

You mentioned you could not use 'locking by deletion' because the row must stay in the table. The code example below does use it, but only after creating a global queue first and populating it. It then uses the 'locking by deletion' for the ##Queue table rather than the table you're working with. USE master GO -- 1. Create a Stored Procedure that ...



Top 50 recent answers are included