Subject Re: gbak trigger(3) error
Author jack.mason58
Thanks for your response. The version of gbak is 2.52 right off the Firebirdsql.com website yesterday. The database was backed up successfully using that version of gbak, but would not restore without the indicated error.

gbak has another problem (will not reliably backup one of our databases) so we would use another backup agent if we could.


--- In firebird-support@yahoogroups.com, Mark Rotteveel <mark@...> wrote:
>
> On Fri, 09 Aug 2013 07:41:27 +0100, Norman Dunbar <Norman@...>
> wrote:
> > On 08/08/13 19:27, jack.mason58 wrote:
> >> gbak: ERROR: table/procedure has non-SQL security class defined
> >
> > From
> >
> http://sourceforge.net/mailarchive/forum.php?thread_name=5106F9F2.4040200%40ibphoenix.com&forum_name=firebird-devel
> >
> >
> > At 01:07 a.m. 29/01/2013, Dmitry Yemanov wrote:
> >
> > >AFAIR, this is a known issue. ODS 11.2 databases cannot be restored on
> > >older FB versions because it has other conventions to name security
> > >classes (SQL$number instead of SQL$tablename, this was done to fix the
> > >old security issue with longer than 27 chars metadata names) and these
> > >new names, after being backed up successfully, are not accepted by
> older
> > >FB versions due to their system triggers expecting the name in the old
> > >format (SQL$tablename).
> > >
> > >I don't know about any solution other than migrating via a script.
> >
> >
> > Might be helpful?
>
> This might indicate that the gbak version used is from an older version of
> Firebird.
>
> Mark
>