Temporal trigger in PostgreSQL DB

Question

Is it possible to define a temporal (i.e. time/date based trigger) in PostgreSQL?

Consider I store a table with some data, that also contains a field for timestamp. This timestamp field is the date/time that I want a certain function to be triggered?

Is it possible to associate a trigger with this table, that can execute the desired trigger at the given time?

Frank Heikens · Accepted Answer · 2011-12-19 06:40:17Z

1

This is what pgAgent does.

answered Dec 19, 2011 at 6:40

Frank Heikens

129k26 gold badges157 silver badges153 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Erwin Brandstetter · Accepted Answer · 2011-12-20 11:40:06Z

1

Or use cron-jobs on a UNIX / LINUX systems. Something like

psql -p5432 mydb -c 'SELECT myfunction()'

as system user postgres which is set up to log in without password.

answered Dec 20, 2011 at 11:40

Erwin Brandstetter

669k160 gold badges1.2k silver badges1.3k bronze badges

Comments

user330315 · Accepted Answer · 2011-12-18 18:52:22Z

0

No, this is not possible. Triggers are only fired through SQL statements (INSERT, UPDATE, DELETE)

answered Dec 18, 2011 at 18:52

user330315

Collectives™ on Stack Overflow

Temporal trigger in PostgreSQL DB

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related