Subject | Re: [firebird-support] FB 2.1: GTT explanation |
---|---|
Author | Vlad Khorsun |
Post date | 2008-04-22T07:57:51Z |
> So, are there some risks to make some triggers (mine) to have aIt is impossible to create trigger for permanent master table which will
> "reference behaviour"?
see data from all GTT instances. This trigger will see only GTT instances
which it allowed to see - from the same connection or transaction.
From the other side, if you have permanent master table which PK is
never deleted or updated then you can safely refer to such master table
from detail tables of any kind and without need to declare FK.
> (by the way, here "references" doesn't mean "dependencies", does it?)Of course. But you must always take into account scope of GTT.
Regards,
Vlad