| Subject | Re: Which connection causes object in use - is there a way to find that out? |
|---|---|
| Author | |
| Post date | 2016-10-25T08:20:02Z |
---In firebird-support@yahoogroups.com, <t.tyrakowski@...> wrote :
No, sorry (one can use lock manager but it is not trivial)
Regards,
Vlad
Run DDL statement in wait transaction. Better to set some timeout to not wait too much, but not no-wait mode> From time to time, when I try to alter a stored procedure in a
> production database, I get "object in use" error.
> I was wandering, isprocedure from being altered?
> there a way to find the connections (users) that prevent a particular
>
No, sorry (one can use lock manager but it is not trivial)
Regards,
Vlad