Subject RE: [firebird-support] Create System Table
Author Alan McDonald
> >
> > Is there another update on system tables which makes this table
> > persist?
> No, alas.
> > Is the backup process dominated by a hardwired list of
> system tables?
> I believe that it's the backup side that ignores anything
> marked as system. If that were changed and restore were
> tested, it might be possible to add triggers to system tables.
> Regards,
> Ann

OK seems like a perfect use of these backup restore engines which provide a
pre-backup and post-restore script to run against the DB
i.e. flag system=0 on the selected objects pre-backup and then update them
back to 1 post restore.
I'll try it