Groups | Search | Server Info | Login | Register

Groups > comp.databases.ingres > #3908

Rules and commit

Show all headers | View raw

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? 

Back to comp.databases.ingres | Previous | Next — Next in thread | Find similar

Thread

Rules and commit Chris <vcxris@gmail.com> - 2023-12-01 13:12 -0800
  Re: Rules and commit Roy Hann <specially@processed.almost.meat> - 2023-12-02 00:48 +0000

csiph-web