Re: row vs row.column level locking

From: NetComrade <netcomradeNSPAM_at_bookexchange.net>
Date: Fri, 16 Dec 2005 18:43:52 GMT
Message-ID: <43a30996.269766578@localhost>

On Fri, 16 Dec 2005 02:00:36 GMT, Mladen Gogala <gogala_at_sbcglobal.net> wrote:

>On Thu, 15 Dec 2005 23:09:28 +0000, NetComrade wrote:
>
>> on column level RDBMS will need to track more changes on a sub-row
>> level (e.g. the way UNDO and oracle blocks are architected might have
>> to change).
>
>So, essentially you feel that somebody ought to change name on my bank
>account, while I'm making deposit? Me thinks not. Programming problems
>usually have less ridiculous solutions.

Your name will most likely be stored in a separate table if the table is normalized :) The PK on your account would be the account#. Unless there is a additional business logic, I see no issues (on the db side) of updating your name while you're making a deposit. .......
We run Oracle 9.2.0.6 on RH4 AMD
remove NSPAM to email Received on Fri Dec 16 2005 - 12:43:52 CST