Subject Re: [firebird-support] Error creating Foreign key
Author Svein Erling Tysvær
Post date 2018-06-13T07:32:51Z
What are the names of the foreign keys? Just in case Firebird thinks two foreign keys are identical, e.g. the naming of both foreign keys have the same first 27 letters and only differ later (don't know if the limit is 27, I think it was 27 or 28 for tables earlier, have no clue about FKs). Are you allowed to create the foreign key if you use a completely different name for it?

And what is the exact definition of the primary, foreign and unique keys for the tables in question?

Set

2018-06-12 10:59 GMT+02:00 Mourad Hedfi mourad@... [firebird-support] <firebird-support@yahoogroups.com>:


Hello All,

I return to you after many tests and finally I've found that when I've two or more successive FK to create, only the first is created and I've the error "Object in use" for the others.

I've tried : 
1. Add a commit command after every FK create command 
2. Disconnect  after every FK create command

==> always the same error.

Doe's anyone have an idea to fix this problem ?

Bien cordialement.

Mourad Hedfi
Directeur de projets
Tél. : 01 83 62 36 85

2018-05-31 9:22 GMT+01:00 Mourad Hedfi <mourad@...>:
Hello,

Thanks for your reply.

1. Why do you remove all FK?
--> Data update covers all data's tables. I must remove all FK to be able to insert, delete records.


2. Why do you still use such old Firebird version?
--> You are wright. It's a big client database and I mist have it's agreement to use a recent version.


Many things was fixed since FB1.5 and i suppose that only real fix to your problem is using recent FB.

You can try disconnect after every FK.

--> I'll try this and tell you if it resolve the problem. Note that on 477 deleted FK, 326 are created.


You can also try do select count(*) from updated tables but you say that you do backup and restore...



Bien cordialement.

Mourad Hedfi
Directeur de projets
Tél. : 01 83 62 36 85

2018-05-31 8:42 GMT+01:00 liviuslivius liviuslivius@... [firebird-support] <firebird-support@yahoogroups. com>:
 

Hi,

Two questions 
1. Why do you remove all FK?
2. Why do you still use such old Firebird version?

Many things was fixed since FB1.5 and i suppose that only real fix to your problem is using recent FB.

You can try disconnect after every FK.
You can also try do select count(*) from updated tables but you say that you do backup and restore...



Regards,
Karol Bieniaszewski