I've been looking at the new trigger features planned for Firebird 2.1
and I'm a bit jealous.
I'm interested in 'stateful' proc packages that can benefit from
accumulating data from updates
during a transaction and then performing an action at the end - perhaps
doing a bulk insert
in a pre-commit trigger, or communicating with an external system in a
post-commit trigger,
and using a begin tran or rollback trigger to tidy up the accumulator.
Would this be a difficult thing to add?
I quite like their temporary table treatment too.
James
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
