Triggers

hi,

on page 8-2 in the apllication developpers guide they warn not to programm recursive after-update-triggers.
is this realy possible?
later they say, that a trigger is not allowed to read or write the table with is written by the fireing sql statement (mutating table). so there is no chance to programm an recursive trigger. am i right?

what do you think of this concept? they say that a trigger should always see a consistent database. but i say, the trigger is part of the transaction, so only after terminating, the database must be consistant. (is consistant the right translation for the german 'konsitent'?, means s.th. like data is o.k.)

and what do you think of the missing select-trigger? i want to implement security checks not only for insert or update, but also for select.

bye,
Dirk Slootz

--


                    | Voice:    (089) 319 42 73    


Dirk Slootz         | Internet: slootz_at_informatik.tu-muenchen.de 


                    | Fido:     2:2480/120.5