Mutex via database

From: Enrico Weigelt <weigelt(at)metux(dot)de>
To: pgsql-sql <pgsql-sql(at)postgresql(dot)org>
Subject: Mutex via database
Date: 2005-05-04 11:28:46
Message-ID: 20050504112846.GA8968@nibiru.borg.metux.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


Hi folks,

i've a dozen of servers processing jobs from a database.
Some servers may only run exactly once, otherwise I'll get jobs
done twice.

Is there any way for implementing an kind of mutex within the
database, which is automatically released if the holding
process/connection dies ?

thx
--
---------------------------------------------------------------------
Enrico Weigelt == metux IT service
phone: +49 36207 519931 www: http://www.metux.de/
fax: +49 36207 519932 email: contact(at)metux(dot)de
---------------------------------------------------------------------
Realtime Forex/Stock Exchange trading powered by postgresSQL :))
http://www.fxignal.net/
---------------------------------------------------------------------

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Markus Schaber 2005-05-04 11:38:30 Re: Mutex via database
Previous Message Sonic 2005-05-04 07:31:15 CASCADE and TRIGGER - Some weird problem