Treeve, > I regularly run a set scripts to migrate an old Paradox db to Firebird. > > The scripts have the following pattern. > > 1.define original ddl > 2.import data > 3.alter tables > 4.add indexes > 5.rearrange data > 6.check consistency > 7.add views > 8.delete old data > > Since a few days I get an error at stage 3, stating 'index in use' while > trying to delete a unique index; > > SQL> input build.sql ; > Statement failed, SQLSTATE = 42000 > unsuccessful metadata update > -object INDEX is in use > After line 50 in file alter1.sql > Statement failed, SQLSTATE = 42S22 > unsuccessful metadata update
This seems to be an item which should really be discussed in the Support mailing list (http://groups.yahoo.com/group/firebird-support/), not here in the core developers lists. Sean ------------------------------------------------------------------------------ CenturyLink Cloud: The Leader in Enterprise Cloud Services. Learn Why More Businesses Are Choosing CenturyLink Cloud For Critical Workloads, Development Environments & Everything In Between. Get a Quote or Start a Free Trial Today. http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel