CODEWITHSUNDEEP
databaseforeign-keysfirebird
Ricardo Acras
Ricardo Acras

Reputation: 36244

Firebird 1.5.3: How to add FK with connected users to the DB?

I use FB1.5.3 and need to eventually add some FK to the database. It happens that if I try to do it while anyone else is connected to the DB I get an exception.

Is there a way to add an FK while the system is running?

Upvotes: 3

Views: 468

Answers (2)

Milan Babuškov
Milan Babuškov

Reputation: 61148

There's no way.

It's a known limitation that has been removed in Firebird 2.0. You should either upgrade, or live with it.

Upvotes: 3

Douglas Tosi
Douglas Tosi

Reputation: 2350

I believe this is a limitation on firebird 1.5 and earlier.
Try google for (firebird foreign key "object is in use").
hth

Upvotes: 0

Related Questions