Carlos,
Frequently I modify stored procedures and triggers.
If some user were connected before I started my transaction (the
one which changes the stored procedure) he will still be using the
unmodified version of the stored procedure. On the other hand, users who
connects after I commit my transaction will be using the modified version.
In that case is there a risk that two different versions of the
same stored procedure coexist (in different transactions) or, as you
say, the "object is in use error" prevents this conflicts and only
allows me to alter the stored procedure when no user is excecuting it ?
Thanks,
Aldo
El 22/03/14 20:44, Carlos H. Cantu escribió:
It depends on what kind of changes you plan to do. Some of them still
needs exclusive access, otherwise you may end up with an "object is in
use" error.
Carlos
Firebird Performance in Detail - http://videos.firebirddevelopersday.com
www.firebirdnews.org - www.FireBase.com.br
AC> Hello,
AC> I wonder if is it sure to perform changes to the database metadata
AC> while there are still users connected.
AC> Up to now, I allways shut the database down, perform DDL changes, and
AC> put it back on line.
AC> Is it actually necessary to do that ?
AC> Thanks for any help.
AC> Aldo Caruso
AC> ------------------------------------
AC> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
AC> Visit http://www.firebirdsql.org and click the Resources item
AC> on the main (top) menu. Try Knowledgebase and FAQ links !
AC> Also search the knowledgebases at http://www.ibphoenix.com
AC> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
AC> Yahoo Groups Links
