Hello expert I am working in banking software vendor company and we are working in PostgreSQL database due to load of work in office time(pick hour) I want to execute some function in specified time(off hour) with trigger. So please if you have any idea please help me.
2
-
Solution smells a bit. But put an if statement in your trigger checking the current hour and if 11pm for example continue with it, else don,t. I think this is dangerous though, as for one record the trigger will fire and for others they won’t, thus some rows have data modified via trigger and some don,t. The result isn’t idempotent, unless you are curing all rows previously missed. If this is the case why not schedule a sql to fire once a dayAb Bennett– Ab Bennett2017-11-20 11:03:58 +00:00Commented Nov 20, 2017 at 11:03
-
trigger saves NEW.PK_COLUMN to a SCHEDULED table. then schedule a job that will on wanted time go through SCHEDULED table, processing ids and removing them from SCHEDULED table. of course it would work only in case of linear changes.Vao Tsun– Vao Tsun2017-11-20 11:27:48 +00:00Commented Nov 20, 2017 at 11:27
Add a comment
|
1 Answer
A trigger should always be something fast. You don't want to hold transactions open for a couple of hours, that would be a really bad idea.
The correct solution for such a problem would be a queue. There are some existing implementations like PGQ, but I don't know if the'll meet your requirements.
