X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4215E5385B for ; Wed, 4 May 2005 08:28:52 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 35181-06 for ; Wed, 4 May 2005 11:28:46 +0000 (GMT) Received: from metux.de (seven.metux.de [193.16.1.1]) by svr1.postgresql.org (Postfix) with ESMTP id 774715381B for ; Wed, 4 May 2005 08:28:44 -0300 (ADT) Received: (from weigelt@localhost) by metux.de (8.12.10/8.12.10) id j44BSkbS010991 for pgsql-sql@postgresql.org; Wed, 4 May 2005 13:28:46 +0200 Date: Wed, 4 May 2005 13:28:46 +0200 From: Enrico Weigelt To: pgsql-sql Subject: Mutex via database Message-ID: <20050504112846.GA8968@nibiru.borg.metux.de> Reply-To: weigelt@metux.de Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.4.1i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200505/35 X-Sequence-Number: 21348 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@metux.de --------------------------------------------------------------------- Realtime Forex/Stock Exchange trading powered by postgresSQL :)) http://www.fxignal.net/ ---------------------------------------------------------------------