|Subject||Re: [firebird-support] Stored procedures vs. indexes|
>> You are correct - when I shutdown the server after index deletion, theThat seems not to be the case - my update script is run by one
>> error disappears. Now I wonder - can I somehow invalidate the metadata
>> cache using SQL, or possibly using API itself? My servers are not always
>> easily accessible for shutdown and restart.
> Detaching all current sessions (for that database) should do the trick, this
> will unload the database on the server and therefor clear the metadata
application, and the procedure is executed by another application. As
far as I know, at the moment of the update there is just one connection
to the server, the one that performs the update. Other connections start
only after the update connection ends (with a delay of at least a few
> It's always a bad idea to do metadata changes while applications are stillIndeed. That's why I don't do it.