This article tells you why SELECT FOR UPDATE is almost always the wrong lock and that you should use SELECT FOR NO KEY UPDATE instead.| CYBERTEC PostgreSQL | Services & Support
