> From: "Todd E. Brasseur" <todd@...>

...

> Firebird-1.0.0.796-Win32.exe

...

> Another thing that has happened to this table a couple of times is that
> we have a Primary Key defined. But when we backup and restore the
> database we get an error saying the Primary Key has been violated. When
> I look in the database I can find a record that violates the Primary Key.
>
> Our database consists of approx. 150 tables. There over 500 stored
> procedures and over 472 triggers.

You have very old Firebird version, you should upgrade either
to FB 1.0.3 or FB 1.5.
There used to be a bug in SP/triggers (I do not remember in which version
it was fixed) that caused data were not properly undone when exception
occured in SP, thus causing violation of PK during restore.

Ivan