CODEWITHSUNDEEP
sqlpostgresqlstored-procedures
hcarrasko
hcarrasko

Reputation: 2352

run a trigger in an interval time in postgres

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();

Upvotes: 5

Views: 17105

Answers (1)

Mike Sherrill 'Cat Recall'
Mike Sherrill 'Cat Recall'

Reputation: 95582

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.

Upvotes: 10

Related Questions