How to create a timed trigger in postgresql

Question

How to create a timed trigger in postgresql

I have a table in my database (postgres) that stores a user account in it. I need to create a trigger that will clean up in a specific amount of time (say 30 minutes.) Is it possible to do this from postgres, or do I need to use something else? (By anything else, I mean C or Java or any other programming language that can sleep for a certain amount of time).

+3

triggers postgresql timer

artaxerxe 21 Mar 12 at 12:42

source to share

2 answers

Frank heikens · Answer 1 · 2012-03-21T12:50:35+0000

You can use pgAgent to schedule events.

wildplasser · Answer 2 · 2012-03-21T13:20:30+0000

Without PgAgent, things like this can be done with a cron script.

In both cases, the periodic thing will run from a different context (database owner, superuser, postgres) and in a separate transaction, obviously.

How to create a timed trigger in postgresql

More articles: