| Subject | Re: [ib-support] Help. Need to add a foreign key, but "object is in use" error in single-user mode. |
|---|---|
| Author | Paul Reeves |
| Post date | 2002-10-06T06:01:10Z |
Andrew Guts wrote:
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.
Work has been done on this issue in Fb 1.5, although I don't yet know
how successful it has been.
Paul
--
Paul Reeves
http://www.ibphoenix.com
Supporting users of Firebird and InterBase
> 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.
Work has been done on this issue in Fb 1.5, although I don't yet know
how successful it has been.
> By the way, is itNo.
> possible to get list of database objects, modified after specified date?
Paul
--
Paul Reeves
http://www.ibphoenix.com
Supporting users of Firebird and InterBase