Mutex via database - Mailing list pgsql-sql

From Enrico Weigelt
Subject Mutex via database
Date
Msg-id 20050504112846.GA8968@nibiru.borg.metux.de
Whole thread Raw
Responses Re: Mutex via database  (Markus Schaber <schabi@logix-tt.com>)
List 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:
+4936207 519931         www:       http://www.metux.de/ fax:       +49 36207 519932         email:
contact@metux.de
--------------------------------------------------------------------- Realtime Forex/Stock Exchange trading powered by
postgresSQL:))                                           http://www.fxignal.net/
 
---------------------------------------------------------------------


pgsql-sql by date:

Previous
From: Frank Bax
Date:
Subject: Re: Function or Field?
Next
From: Markus Schaber
Date:
Subject: Re: Mutex via database