--- In ib-support@y..., Paul Reeves <paul@f...> wrote:

> Andrew Guts wrote:
> > Thank you, Paul. But I was single user at that time.
>
> That doesn't matter. Once you start working with the database the

engine

> starts caching metadata. The only solution to your problem, at

present,

> is to restart the server, open the database and execute your

statement

> before doing anything else.

Paul, I had reports that sometimes doing a lot of FK creation
(re-design database) even disconnect/connect does'nt help. Seems it is
possible that automatically started sweep gives the same effect in
metadata cashing, so, before doing such changes it is better to turn
off autosweep.

Best regards, Alexander V.Nevsky.