Path: utzoo!utgpu!jarvis.csri.toronto.edu!cs.utexas.edu!uunet!mcsun!sunic!dkuug!modulex!bni
From: bni@modulex.dk (Bent Nielsen)
Newsgroups: comp.databases
Subject: Lock problem on Ingres, Please help.
Keywords: Ingres
Message-ID: <673@modulex.dk>
Date: 13 Feb 90 05:56:02 GMT
Organization: A/S MODULEX, Copenhagen, Denmark
Lines: 17

Someone has explained to me how Ingres lock is working, but I
don't understand it, please help.

1) Is it correct that if I have a record length of 128 bytes
   and uses SELECT .... FOR UPDATE on one record then 4 records,
   one whole page (512 bytes on UNIX), will be locked?

2) I am familiar with Oracle SQL*Forms and Forms is using
   SELECT .... FOR UPDATE, when a user start to change a
   retrieved record and only this record will be locked.
   How can I implement this in Ingres if 1) is correct?
--
Bent Nielsen		<bni@modulex.dk>
A/S MODULEX
Lyskaer 15
DK-2730 Herlev
Denmark