Subject Re: [firebird-support] Re: Which connection causes object in use - is there a way to find that out?
Author Tomasz Tyrakowski
On 25.10.2016 o 10:20, hvlad@... [firebird-support] wrote:
>> From time to time, when I try to alter a stored procedure in a
>> production database, I get "object in use" error.

> Run DDL statement in wait transaction. Better to set some timeout to not wait too much, but not no-wait mode
> No, sorry (one can use lock manager but it is not trivial)

Thanks Vlad. I'll play a bit with wait transactions and see if it helps
at least in some cases. At least I know there's no easy way which my
ignorance prevents me from seeing ;)