Alarm function in PL/pgSQL - Mailing list pgsql-general

From Jon Smark
Subject Alarm function in PL/pgSQL
Date
Msg-id 1311025139.73351.YahooMailClassic@web112801.mail.gq1.yahoo.com
Whole thread Raw
Responses Re: Alarm function in PL/pgSQL
List pgsql-general
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


pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Documentation issue
Next
From: John R Pierce
Date:
Subject: Re: pg_upgrade does not translate tablespace location to new cluster