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
 

 

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