Re: [Firebird-test] Firebird does not create unique constraint.

[Mike S. ( a. x. ) <xsa...@sb...>]

Leyne, Sean wrote:
> A Firebird index includes index data for all active transactions, this
> is by design.
>
> Accordingly, what you are seeing is the correct behaviour.
>
>
> Sean
>   
I know that. The question is why there were active transactions 
affecting the new index. I don't think this is a new issue. See CORE-400 
<http://tracker.firebirdsql.org/browse/CORE-400> in bug database. I have 
a copy of the database running on FB 1.5 and the same operation went 
through fine there.

I have only been using the FireBird DB, did not get into development of 
debugging, so I don't know all the secrets. More of the end user point 
of view.

-- 
Mike Starov
mik...@gm...

CME Resource, Inc.
Roseville, CA 95661
www.netce.com
(916) 783-4238