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

From Jon Smark
Subject Re: Alarm function in PL/pgSQL
Date
Msg-id 1311028539.39396.YahooMailClassic@web112804.mail.gq1.yahoo.com
Whole thread Raw
In response to Re: Alarm function in PL/pgSQL  (Merlin Moncure <mmoncure@gmail.com>)
Responses Re: Alarm function in PL/pgSQL
Re: Alarm function in PL/pgSQL
Re: Alarm function in PL/pgSQL
List pgsql-general
Hi,

> I don't think this is really possible with postgres PLs generally.
> Typically what you have to do is have a function that is called on an
> interval that checks for alarms and runs them.

Thanks for the prompt reply.  Just to clarify: you are saying that the
function that is called with a given periodicity must be so from *outside*
PG, ie, from the client application, right?  I mean, there is no way
strictly internal to PG to have a function be called every given number
of seconds?

Cheers,
Jon


pgsql-general by date:

Previous
From: "Hans C. Poo"
Date:
Subject: Database level read only user
Next
From: Darren Duncan
Date:
Subject: Re: Alarm function in PL/pgSQL