>> But why If nobody is using it and it does not apear in mon$statements the >> object is in use? > > Because metadata locks are cached even if not explicitly used (to avoid > repeating acquire/release overhead). > > > Dmitry
Thank you dimitry for the explanation. Then locks for triggers are different from locks from procedures, and both are metadata locks. I can alter triggers with nowait but no procedures. Regards, Jesús García. ------------------------------------------------------------------------------ Open source business process management suite built on Java and Eclipse Turn processes into business applications with Bonita BPM Community Edition Quickly connect people, data, and systems into organized workflows Winner of BOSSIE, CODIE, OW2 and Gartner awards http://p.sf.net/sfu/Bonitasoft Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
