Subject Re: [firebird-support] Restore FB2 problem
Author Helen Borrie
At 11:23 PM 19/10/2007, you wrote:
>When doing a restore from a FB 1.5 database backup, I get the error
>message 'table ... is not referenced in plan'.
>Now I found the remarks in the release notes concerning this situation:
>
>"Stricter validation of user-specified plans
>User-specified plans are validated more strictly than they were
>formerly. If you encounter an exception
>related to plans, e.g. Table T is not referenced in plan, it will be
>necessary to inspect your
>procedure and trigger sources and adjust the plans to make them
>semantically correct."
>
>"Important:
>Such errors could also show up during the restore process when you are
>migrating databases to the new
>version. It will be necessary to correct these conditions in original
>database before you attempt to perform
>a backup/restore cycle."
>
>The only thing is: there are no explicit plans in my entire database.
>So how can I correct this issue?

Have you checked your stored procedure and trigger sources?

Check also view sources, in case you specified a plan there somewhere...even if you think you never did it, you might used some tool that performs this for you.

./heLen