Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!usc!sdd.hp.com!decwrl!shelby!portia.stanford.edu!chesky
From: chesky@portia.Stanford.EDU (Snehylata Gupta)
Newsgroups: comp.databases
Subject: INGRES locking problem?
Message-ID: <1990Jun28.224823.28883@portia.Stanford.EDU>
Date: 28 Jun 90 22:48:23 GMT
Sender: chesky@portia.Stanford.EDU (Snehylata Gupta)
Organization: AIR, Stanford University
Lines: 28

Question for INGRES buffs.

I have INGRES version 6.3 running on VMS. It seems sometimes that INGRES
sometimes takes a lock of some such that when you select that record
it does not show up For example: I have an application out that
accesses a table that looks like this

id number 	|	call date	|	notes
		|			|
		|			|
12345678	|			|	record1
12345678	|			|	record2

I am doing this  (4GL, SQL)

select call_date, notes
from notes_tbl
where id_number = :id

Users have only select and insert grants. I have evidence ( 1 occurence)
that record1 was not selected once but reappeared next time.

If this has happened to you, or you can shed light on this matter call
or email me.

Sanjay

408-439-7182