pgq.maint_retry_events(): lock table to allow only single mover
authorMarko Kreen <markokr@gmail.com>
Thu, 17 Sep 2009 08:46:10 +0000 (11:46 +0300)
committerMarko Kreen <markokr@gmail.com>
Thu, 17 Sep 2009 08:46:10 +0000 (11:46 +0300)
commitd0d852aa00e91858eb2521b44023392eca4f595d
treecd3fa4599c8ee874a86aff88a60d3f6e88cb6faa
parente3ebab4e61cc7aabf04165308ce072351311f4e2
pgq.maint_retry_events(): lock table to allow only single mover

Use SHARE UPDATE EXCLUSIVE lock, which will not conflict with inserts.
sql/pgq/functions/pgq.maint_retry_events.sql