If I have a rule which calls a dbp , triggered AFTER insert. From the documentation I get that the rule is fired and the dbp called regardless
if the transaction rollbacks or commits, because the dbp is considered
part of the transaction. With that I mean that the dbp does not get
fired only after the inserted row is committed. Did I get that right?
What happens if inside the dbp I raise a db event which reads the data
from the AFTER insert statement, but the transaction wrapping the dpb
or the same dbp rollbacks?
Is the db event called regardless if the transaction rollbacks or
commits?, In that case the event can readdirty/ uncommitted or rolled
back data?
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 418 |
Nodes: | 16 (2 / 14) |
Uptime: | 21:53:12 |
Calls: | 8,764 |
Calls today: | 7 |
Files: | 13,287 |
D/L today: |
3 files (1,633K bytes) |
Messages: | 5,964,653 |