[Info-ingres] Rules and commit
Chris
vcxris at gmail.com
Fri Dec 1 21:12:26 UTC 2023
Hi
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?
More information about the Info-ingres
mailing list