Is possible triggering a function in postgres at a timed interval??
For example
CREATE TRIGGER deleteOldRecords BEFORE "TIME_OUT" ON table
FOR EACH ROW EXECUTE PROCEDURE deleteOldRecordsP();
Scheduled database jobs for PostgreSQL are usually done by cron
or pg_agent. The CREATE TRIGGER statement doesn't support timed intervals as a type of event.
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments