Hi Helen,

Ha-ha, we is "the Royal We". Only one connection to the database is trying
to do this. It is not a constraint, it is a named index created previously.

Peter Y

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Helen Borrie
Sent: 26 October 2005 02:38 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Trying to drop an index

At 02:16 PM 26/10/2005 +0200, you wrote:

>We are trying to drop an index and we get an object is in use error. We are
>certain that there are no other connections open to the database and yet we
>get this error. Is there a special trick or something?

Is this "the Royal We" or are there actually more than one of you trying to
do this?

Check for other transactions still running, involving the table that the
index belongs to, and either commit them or roll them back.

If, on the other hand, the index is a constraint index, you can't drop
it. You'll have to find the name of the constraint and drop that.

./heLen





++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Yahoo! Groups Links