[firebird-support] Re: object is in use

2014-08-19 Thread Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]
18.08.2014 23:39, 'Carlos H. Cantu' wrote: > LSSBcfs> While this would avoid the error, you will not know when/if your > change will be applied. > LSSBcfs> A connection can hold an object in use for an indeterminant period > of time. > > Dmitry said to me sometime ago that procedures changes wil

[firebird-support] Re: object is in use

2014-08-19 Thread Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]
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/C

Re: [firebird-support] Re: object is in use

2014-08-19 Thread 'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support]
DYdusnfs> It's not about when your DDL is applied but about the cached procedure DYdusnfs> BLR that is used by others. The changed (new) procedure BLR will be used DYdusnfs> by newly compiled statements immediately after your DDL has been DYdusnfs> executed. However, all already compiled statemen

Re: [firebird-support] Re: object is in use

2014-08-19 Thread Hugo Eyng hugoe...@msn.com [firebird-support]
Hello. Sorry, but I didn´t, yet, understand why I can´t exceute an ALTER PROCEDURE without _*closing all conections and restarting the FB service.*__* *_ I guess that the problem could be related to my application leaving some transaction, that uses the SP, without commit/rollback or somethi