Ivan Prenosil wrote:

> > 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.

We are planning to move everyone from 1.0.0.796 to 1.5 but we have some
changes to do to allow this. Does anyone know if there was a bug in
1.0.0.796 that was fixed in 1.0.3 that might fix my problem? I don't
want to upgrade to 1.0.3 for nothing only to redo it again in a few
months for 1.5.

Todd

>
>
> Ivan
>
>
> ------------------------------------------------------------------------
> Yahoo! Groups Links
>
> * To visit your group on the web, go to:
> http://groups.yahoo.com/group/firebird-support/
>
> * To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
> <mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/>.
>
>

[Non-text portions of this message have been removed]