Arda wrote:

>
> I've been using v1.5 and I've switched to FirebirdCS-2.0.3.12981 about
> a month ago. When I try to create an index on a table and I'm getting
> this error. I've never faced an error like this before when I was
> using v1.5 or v1.0. Is this a bug or is this a feature?

Feature. The only way to create a consistence index is to block the
entire table from concurrent writes.

> It'a bad habit but I'm continuous modifying and developing with the
> same database which is also under production and I need to
> create-modify indexes when the database file is online or I'll be
> working at the night shift too.

The easiest workaround would be to set transaction option for CREATE
INDEX to WAIT instead of NO_WAIT.


Dmitry