03.10.2014 10:31, Martijn Tonies wrote: > > I noticed that with Classic 2.5, you can get “object in use” when trying > to modify a > stored procedure that’s been previously executed, see also: > http://tracker.firebirdsql.org/browse/CORE-4016 > When using “wait” on the transaction to save the procedure, instead of > “nowait”, the problem goes away. > Is it safe to always use “wait” on such transactions?
Yes, it's safe. But I'd suggest to additionally specify the lock timeout for a DDL transaction to avoid unexpected lockups (e.g. if tables are dropped by the same DDL transaction). Dmitry ------------------------------------------------------------------------------ Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel