If you can provide a reproducible test case, it's useful. Otherwise,
guessing becomes hard. Can you cause corruption if you do the same on the
database again? How many connections where in effect when you altered the
procedure?

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing

"Paul Poulain" <paul@...> wrote in message
news:5.1.0.14.0.20011010105426.00a9eec0@......

> Hi !
>
> yesterday, I changed a stored proc in a firebird DB, adding 2 input
> parameters where there was no.
>
> This morning, as every morning, we looked at the automatic backup/restore
> which... failed during restore.
>
> The error message is 'invalid BLR at...'. And this happends while

restoring

> the stored proc.
>
> it's not the first time this happends : we modify something in the
> structure of the DB (add or drop a row in a table...), and, no more
> possibilities to restore a backup...
> Is there a known bug in modifying IB structure.
>
> Note : we also dump the structure in a SQL file, and this worked fine this
> night.
> Platform : Firebird running on RedHat 6.2 (PIII-450 IDE disk), all acces
> are done by a user INTERBASE, which is owner of the DB
>
> Paul
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>