[Info-ingres] Triggers and locks

Roy Hann specially at processed.almost.meat
Wed Sep 13 08:54:29 UTC 2023


Fabrizio Di Renzo wrote:

> Thank you all,
> we will try to use dbevent, I think this is a good idea.
> We never used it, but it seem the better solution.

Keep in mind that a raised event won't be "unraised" if there is a 
rollback, so there is risk of recording things which--in a sense--didn't
happen.

Geraint's partitioning suggestion might be the quickest, easiest, and
most robust thing to try first. It requires no code and can be
backed out quickly if it doesn't help.

Roy (Kicking himself for forgetting to mention his own favorite solution)


More information about the Info-ingres mailing list