Return-Path: owner-postman Delivery-Date: Fri, 22 Apr 94 00:02:58 -0700 Return-Path: owner-postman Received: from localhost (localhost [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id UAA21465 for postgres-redist; Thu, 21 Apr 1994 20:31:51 -0700 Resent-From: POSTGRES mailing list Resent-Message-Id: <199404220331.UAA21465@nobozo.CS.Berkeley.EDU> X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost didn't use HELO protocol Sender: owner-postman@postgres.Berkeley.EDU X-Return-Path: owner-postman Received: from metro.ucc.su.OZ.AU (daemon@metro.ucc.su.OZ.AU [129.78.64.2]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id UAA21456 for ; Thu, 21 Apr 1994 20:31:48 -0700 Received: from van.oz.au by metro.ucc.su.OZ.AU with MHSnet id AA29974 (5.65c/IDA-1.4.4 for postgres@nobozo.cs.berkeley.edu); Fri, 22 Apr 1994 13:31:42 +1000 From: farouk@van.oz.au (Farouk Ho) X-Mailer: SCO System V Mail (version 3.2) To: postgres@postgres.Berkeley.EDU Date: Fri, 22 Apr 94 13:17:45 AEST Message-Id: <9404221317.aa14397@vanbig.van.oz.au> Resent-To: postgres-redist@postgres.Berkeley.EDU Resent-Date: Thu, 21 Apr 94 20:31:51 -0700 Resent-XMts: smtp Newsgroups: vanoco.lists.postgres Path: vanbig.van.oz.au!farouk From: farouk@van.oz.au (Farouk Ho) Subject: help with record locking Organization: Vanoco Pty. Ltd. - Australia Date: 22 Apr 1994 03:17:39 GMT Message-ID: Sender: farouk@van.oz.au (Farouk Ho) Lines: 16 Hi y'all, The situation is this, there are several tasks are accessing a single class with one instance, containing a serial number. Each task can at any time access the instance and update the value by 1 (retrieve and update cmd). What I need is that when a task access the instance, other task should not be able to access it and must wait until the previous task has finish (thus each task should access a different value). Is there a way to stop the 2nd task from accessing before the 1st one has finish ? Is there another way of doing this ? Any help is greatly appreciated and the cheque's in the mail.