Hello [email protected], Saturday, March 19, 2016, 11:51:23 PM, you wrote:
> Regarding thus issue could someone raise a ticket & update the documentation > of firebird. Not necessary. The documentation is under review at this stage. I have added warnings to both RECREATE PROCEDURE and RECREATE TRIGGER which will show up in the next build of the docs, due this weekend. Just as an additional comment for you: RECREATE is useful during development but it is not sensible to use it for "blind" updates to your PSQL modules from end-user applications. It is not arbitrary that the isql tool defaults DDL to autocommit. You should follow this practice in your own work, not least to enable you to catch the error immediately. Even if you write a script that resolves the dependencies before a RECREATE operation, it will still fail if you do not commit the resolution steps before the RECREATE request. Helen
