Subject Re: [firebird-support] RECREATE Procedure issue.
Author Helen Borrie
Hello joje@...,

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

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.