Re: Can these constraint be implemented in an RDBMS ?
From: Mikito Harakiri <mikharakiri_at_iahu.com>
Date: Tue, 2 Mar 2004 09:23:56 -0800
Message-ID: <Rz31c.24$4E5.432_at_news.oracle.com>
Date: Tue, 2 Mar 2004 09:23:56 -0800
Message-ID: <Rz31c.24$4E5.432_at_news.oracle.com>
"ben brugman" <ben_at_niethier.nl> wrote in message
news:4044ac1c$0$3681$4d4ebb8e_at_read.news.nl.uu.net...
> The problem is derived from two accounts which together are not
> allowed to be negative. (Used to illustrate Oracle's failure to implement
> serializability (as defined in most dictionaries and in the
SQL-standard).)
> Most solutions I have seen involve some application coding. And often
> a denial that you actually want those constraints.
Discussing serializability might be interesting. Could you please reduce the problem to possibly no more than 1-2 tables? An example involving half dozen tables is overkill. Received on Tue Mar 02 2004 - 18:23:56 CET