At 08:20 a.m. 8/08/2015, Helen Borrie hele...@iinet.net.au [firebird-support]
wrote:
>OK, when you restored your database, all of the old function declarations were
>restored too. So you need to list out the names of the functions as they are
>declared in the database (print them to a file, because you'll need to refer
>to them) and then drop all of the functions.
Actually, you probably don't need to DROP the old function declarations. In
2.5 you can alter them:
ALTER EXTERNAL FUNCTION funcname
[ENTRY_POINT 'new_entry_point']
[MODULE_NAME 'new_library_name'];
So you should be able to script these alterations, keeping the funcnames but
changing the entry_point and module_name parameters.
Don't forget to COMMIT.
Helen
