Subject Re: Online DDL
Author Dmitry Yemanov
23.03.2014 04:17, Aldo Caruso wrote:
> 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)

Surely this may be undesired, but this "risk" is a documented behavior,