Michael Vilhelmsen schrieb:

> Hi
>
> I wsa wondering what can make a DB (in FB 1.0.3) ignore the unique
> contraint on a PK ?

A long time ago (still with IB5.x) I had the problem that I had a lot of
abandoned detail records (with foreign key constraint, but referring to
non existent master records) which lead to an unrestorable backup-file
(ie as long as you don't killed these records before the backup; so kind
of the same thing you had to do).

Since I had 50 or more similar datanbases outside and this only happened
to one customer I think the problem was:

a) forced writes were switched off
b) there were quite often network problems.

Maybe it would be helpful if you use INTEGER as primary keys instead of
VARCHARS and let these INTs be assigned by using generator values.
(I never was a friend of using a VARHCAR pk; that's what generators are
for - supplying a meaningless unique key)

Luc.