On Thu, Apr 3, 2014 at 2:06 PM, Claudio Valderrama C. <cva...@usa.net>wrote:

>
>
>
> AFAIK, you can put triggers on sys tables and they last until the last
> attachment finished. When the db is loaded again, those triggers do not
> load. I don't know if that changed recently, but was this way since I
> remember.
>

My recollection is that some user modifications to system tables (adding
triggers
or columns) are OK, but disappear after a backup and restore with gbak.
 Gbak
doesn't look for user modifications of system tables and recreates them
from its
understanding of their state in the ODS version being created.

Changing gbak so it backs up user enhancements to the system tables is just
programming, and restoring them after the base table are created isn't
hard, but
both go against the V3 goal of shutting users out of system space.

Cheers,

Ann
------------------------------------------------------------------------------
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to