Subject RE: [firebird-support] Deleted index renders procedures unusable
Author Leyne, Sean
Pepa,

> I decided to delete some useless indexes from my database. That went
> fine. Unfortunatelly, now just about every stored procedure fails to
> execute claiming an error that an index was unexpectedly deleted. Is
> there a way to fix this issue without dropping and recreating every
> single procedure? I am using Firebird 1.5.3 oin Superserver mode on
> Windows XP.

I am 100% sure you problem only applies to objects which were previously
loaded by the server into memory.

So, a shutdown/restart of the database should solve the problem, by
flushing the cached objects.


Sean