[GENERAL] Problem with pg_try_advisory_lock and two connections (seemingly) getting the same lock

2010-07-20 Thread Brett Hoerner
Hi, I currently have a simple queue written ontop of Postgres. Jobs are inserted and workers periodically check for jobs they can do, do them, and then delete the rows. pg_try_advisory_lock is used to (attempt to) stop two workers from doing the same job. (I'm working on moving to a "real" mess

Re: [GENERAL] [pgsql-general] Daily digest v1.8030 (22 messages)

2008-03-31 Thread Brett Hoerner
On Mon, Mar 31, 2008 at 10:54 AM, Colin Wetherbee <[EMAIL PROTECTED]> wrote: > I received eight of these unwanted digests last night and early this > morning, after never seeing them before. Is this a new configuration > change that I need to go personalize? I was wondering the same thing, but