Subject Re: [firebird-support] Does Firebird 2.0 requiere exclsuive access to create indexes?
Author Thomas Steinmaurer
> Hi there, four days ago I upgraded a database from FB 1.5 to 2.0. I
> recall that in version 1.5, exclusive access for tables was not
> required when creating new indexes. Now with 2.0 it seems the case, as
> I get an error when creating a new index for the TRACKING table:
> Unsuccessful execution caused by system error that does not preclude
> successful execution of subsequent statements.
> lock conflict on no wait transaction.
> unsuccessful metadata update.
> object TRACKING is in use.

You always need exclusive access to a table when creating an index.

Although there was a bug in 2.0 up to 2.0.3 which allowed to
create/activate an *expression* index while the table is in use. This
has been fixed in 2.0.4 and 2.1.

Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
My blog: