Subject Re: [ib-support] How to alter SP wihout restarting the server?
Author Martijn Tonies

> > > How to alter SP wihout restarting the server? Is it any
> > > way to enforce the server to accept changes. After
> > > altering the stored procedure server
> > > continues to work with old instance till restart. Please help.
> >
> > I believe everyone needs to disconnect - metadata is cached
> > on the server side.
> AFAIK, not really. When a SP is altered, its new metadata is reloaded to
> cache, but already compiled requests see the old version. So the only
> required thing should be to commit/rollback all running transactions that
> could explicitly or implicitly use this SP and then restart them.

That would explain why you can happily test when you're pretty much the
only one connected :)


Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird

Upscene Productions

"This is an object-oriented system.
If we change anything, the users object."