Subject | CHECK Constraints (was: Re: [firebird-support] Re: Checking periods don't overlap) |
---|---|
Author | johnsparrowuk |
Post date | 2004-06-15T22:23Z |
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:
(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.