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.

True.

> 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,
AFAIK.


Dmitry