home *** CD-ROM | disk | FTP | other *** search
/ NetNews Usenet Archive 1992 #19 / NN_1992_19.iso / spool / comp / database / informix / 1803 < prev    next >
Encoding:
Internet Message Format  |  1992-08-26  |  774 b 
  1. Path: sparky!uunet!munnari.oz.au!mel.dit.csiro.au!yarra!bohra.cpg.oz.au!jan
  2. From: jan@bohra.cpg.oz.au (Jian Cai)
  3. Newsgroups: comp.databases.informix
  4. Subject: C-ISAM: deleting record also removes lock
  5. Message-ID: <1992Aug26.232000.12106@bohra.cpg.oz.au>
  6. Date: 26 Aug 92 23:20:00 GMT
  7. Organization: Computer Power Software
  8. Lines: 11
  9.  
  10. Can anyone confirm (or reject) this statement:
  11.  
  12. C-ISAM, while in a transaction, removes the lock (if any) on a record
  13. upon deletion of the record.
  14.  
  15. If this is true, and if the file is not locked, another transaction
  16. can insert a record with the same key, and both are successful:
  17.    transaction 1                    transaction 2
  18.   delete record1
  19.                                      insert record1
  20.    commit                            commit
  21.