Re: Alarm function in PL/pgSQL

From: Jon Smark <jon(dot)smark(at)yahoo(dot)com>
To: Merlin Moncure <mmoncure(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Alarm function in PL/pgSQL
Date: 2011-07-18 22:35:39
Message-ID: 1311028539.39396.YahooMailClassic@web112804.mail.gq1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Darren Duncan 2011-07-18 22:47:18 Re: Alarm function in PL/pgSQL
Previous Message Shianmiin 2011-07-18 22:18:43 Another unexpected behaviour