><Ivan.Prenosil@s...> wrote:
> > Do you think the problem lies in multi-versioning ?

At 08:11 AM 6/16/2004, johnsparrowuk wrote:

>I think if you guys can't make this work properly then it's a
>weakness, yes.

It's a weakness in the implementation of constraints, but has
nothing to do with multi-versioning. In a conventional locking
system you would have the same problem unless you lock the
table while you write to it and hold the lock until you commit.
The solution is not to allow user code to read uncommitted
records, but to redesign the implementation of constraints so
they work more like unique indexes and less like triggers.

Regards,


Ann