Subject CHECK Constraints (was: Re: [firebird-support] Re: Checking periods don't overlap)
Author johnsparrowuk
Out of interest, does anyone know how Oracle, SQL Server 2005
(Yukon) and other multi-versioning systems cope with check
constraints? Do they see uncommitted records? To they defer and fail
on commit? Or just let it pass?

John

--- In firebird-support@yahoogroups.com, "johnsparrowuk"
<jsparrow@e...> wrote:
> I just want unique constraints to *work* (or, more specifically,
> time overlap constraints). If they don't then it's a big
> deficiency...
>
> And they sure don't work properly at the moment.