Return-Path: pg_adm@postgres.berkeley.edu
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA16753; Thu, 4 Feb 93 08:48:00 -0800
Message-Id: <9302041648.AA16753@postgres.Berkeley.EDU>
From: Herb HASLER <herb@iiasa.ac.at>
Subject: Multiple user access.
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu
To: postgres@postgres.Berkeley.EDU
Date: Thu, 4 Feb 1993 17:26:20 +0100 (MET)
X-Mailer: ELM [version 2.4 PL8]
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Content-Length: 767       


If I do the following:

% monitor db
* begin \g
* retrieve portal myportal (whatever.all) \g



and at then go to another widow and enter

% monitor db
* delete whatever where whatever.somefield = somevalue \g


that the delete hangs until the I close the portal.   Is there a way to
have the delete return with an error or signal the initial process that
someone wants to do something with data that it is currently is using?


---------------------------------------------------------------------------
                    Herb Hasler --- herb@iiasa.ac.at
      International Institute for Applied Systems Anaylsis  (IIASA)
          A-2361 Laxemburg, Austria --- +43 2236 715 21 ext 548
---------------------------------------------------------------------------