Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 367694764F6 for ; Wed, 14 Aug 2002 18:28:29 -0400 (EDT) Received: from beamish.nsd.ca (unknown [205.150.156.194]) by postgresql.org (Postfix) with ESMTP id 76CD74763F1 for ; Wed, 14 Aug 2002 18:28:28 -0400 (EDT) Received: (from smap@localhost) by beamish.nsd.ca (8.9.3/8.9.3) id SAA10688 for ; Wed, 14 Aug 2002 18:28:30 -0400 X-Authentication-Warning: beamish.nsd.ca: smap set sender to using -f Received: from reddog.nsd.ca(192.168.101.30) by beamish.nsd.ca via smap (V2.1/2.1+anti-relay+anti-spam) id xma010686; Wed, 14 Aug 02 18:28:08 -0400 Received: from nsd.ca ([192.168.101.148]) by reddog.nsd.ca (8.8.7/8.8.7) with ESMTP id SAA21896 for ; Wed, 14 Aug 2002 18:28:08 -0400 Message-ID: <3D5AD9BF.F127D21A@nsd.ca> Date: Wed, 14 Aug 2002 18:29:19 -0400 From: Jean-Luc Lachance X-Mailer: Mozilla 4.77 [en] (X11; U; Linux 2.4.9-31 i686) X-Accept-Language: en MIME-Version: 1.0 Cc: pgsql-interfaces@postgresql.org Subject: BUG: PGACCESS does not warn when trying to update a record that was deleted by someone else. References: <20020405083629.6a97dcde.dbr@informactis.com> <24205.1018020022@sss.pgh.pa.us> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200208/47 X-Sequence-Number: 3009 DARN!!! I have just wasted half a day updating record with PcAccess. If one is updating a record that was deleted by someone else, PgAccess does not warn that the record no longer exists and silently accept the update. Then, if the list is refreshed, the record is gone!!!