[[firebird-support] Modifying unique constraint]
Rick Debay schrieb am 03.06.2010 um 12:15:14 (-0400):

> I need to modify a unique constraint. I do this by dropping the
> constraint and then adding it again. However, I get an 'INDEX is in
> use' error when I commit the transaction. The only connection to the
> database is the one I'm using to perform this action.
> What do I need to do to modify this constraint?
>
> ISC ERROR CODE: 335544351
> ISC ERROR MESSAGE: unsuccessful metadata update object INDEX is in use

Provided that you're using ISQL here, try issuing a COMMIT before doing
the DDL. If that doesn't work, try disconnecting and reconnecting. If it
still doesn't work, try shutting down and restarting the server.

--
Michael Ludwig