Received: from post.mail.demon.net (post-11.mail.demon.net [194.217.242.40]) by hub.org (8.8.8/8.7.5) with SMTP id PAA24935 for ; Thu, 28 May 1998 15:01:41 -0400 (EDT) Received: from (wibble.brook.st) [193.237.6.55] by post.mail.demon.net with smtp (Exim 1.82 #2) id 0yf7vo-00025J-00; Thu, 28 May 1998 19:01:40 +0000 Message-ID: <356DB341.7CB2@ewtoo.org> Date: Thu, 28 May 1998 19:56:01 +0100 From: M Simms X-Mailer: Mozilla 3.0Gold (Win95; I) MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: oops and a question Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit I think I may have just sent my subscribe to the wrong address. Oh well, never mind. I have a question. Ive been looking through the documentation, and cannot seem to find anything that may help me. I am going to be running quite a large database using posrgresql in a few weeks time, and Im just setting it up now. The program that interfaces with the database could be called a number of times at once (under linux, its a setuid program for the database manipulation). Now, one of the operatins this database is going to need to do is incriment a value in the database. Looking through the documentation I can fnd no way to make sure that whilst I am incrimentng a value from x to x+1, another process wont come along and try and incriment x before the first has finished its incriment, and thus I lose out on one count. Any idea on how to ensure it will not happen in this way, or am I going to have to write a separate client to handle connections on a socket that is the ONLY process that will incriment this number? Thanx for any help anyone can suggest M Simms