| Subject | Re: [firebird-support] Re: Which connection causes object in use - is there a way to find that out? |
|---|---|
| Author | Tomasz Tyrakowski |
| Post date | 2016-10-25T09:07:09Z |
On 25.10.2016 o 10:20, hvlad@... [firebird-support] wrote:
at least in some cases. At least I know there's no easy way which my
ignorance prevents me from seeing ;)
regards
Tomasz
>> 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 ;)
regards
Tomasz