19.08.2014 21:56, Hugo Eyng wrote: > > Sorry, but I didn´t, yet, understand why I can´t exceute an ALTER > PROCEDURE without _*closing all conections and restarting the FB > service.*__*
You can. > I notice that i am not the only one facing this trouble: > http://tracker.firebirdsql.org/browse/CORE-3108 They use NOWAIT transactions, hence the issue. > Using and WAIT or NO WAIT Transaction, in my opinion, is not the answer, > or at least no the best answer. Maybe not the best, but it works. Do you really need to resolve the issue or not? > I tried to find 'who' or 'what' is using the STORED PROCEDURE while I am > trying to excecute the ALTER, but I was not able to do it. There are no ways to find that, except the low-level trickery with fb_lock_print. Dmitry ------------------------------------ ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ------------------------------------ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
