--- In firebird-support@yahoogroups.com, "Martijn Tonies"
<m.tonies@u...> wrote:

> Hello,
>
> > I'm using Firebird 1.5.2
> > I try to issue the following command
> >
> > alter table DIORTHOTIKO
> > add constraint FK_DIORTHOTIKO_1
> > foreign key (ETOS_PROT,SEIRA_PROT,AR_PROT)
> > references BOOK(ETOS,SEIRA,AR_PROT)
> >
> >
> > and I get the error message
> >
> > This operation is not defined for system tables.
> > unsuccessful metadata update.
> > object BOOK is in use .
> >
> > Only SYSDBA is connected to the database.
>
> Sure, but how many times?
>
> To create a foreign key, there can be only 1 connection
> to a database.
>
> > I have extracted metadata to a script from the database
> > and create a new database from the script.
> > Then I export the data from the first database
> > and import the data to the second database.
> >
> > To the second database I can issue the command
> > alter table with no problem.
>
> With regards,
>
> Martijn Tonies
> Database Workbench - developer tool for InterBase, Firebird, MySQL

& MS SQL

> Server
> Upscene Productions
> http://www.upscene.com

I'm using IBexpert as GUI to firebird
IBExpert shows connection for each user
if for example SYSDBA is connected two times
it would show him two times.
After all IBexpert is the only program running
and I'm not connected to any network.
My only concern is, if this is a problem of
firebird and what have I done to cause this problem.