Hi, Is it possible to set an alarm within a PL/pgSQL function? By "alarm" I mean a function which is invoked some defined time in the future, even after the original function has terminated and returned a value to the client.
I want an invocation of function FOO to set a "state" column of a given table row to "temporary". After a predefined period (say, one hour), function BAR should then automatically be invoked; this latter function would among other things change the "state" column to "permanent". Thanks in advance! Jon -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
