Skip site navigation (1) Skip section navigation (2)

Re: LOOP and EXIT

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Sebastian Kühner <support(at)veraza(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: LOOP and EXIT
Date: 2005-07-14 14:29:51
Message-ID: 20050714072802.V15619@megazone.bigpanda.com (view raw or flat)
Thread:
Lists: pgsql-admin
On Tue, 12 Jul 2005, [iso-8859-1] Sebastian Kühner wrote:

> Hello,
>
> I'm new here in this group... and I hope that I find the solution for my
> problem here.
>
> I wrote a simple function which looks like this:
>
> CREATE OR REPLACE FUNCTION watchdog() RETURNS TIME AS '
>  DECLARE
>   watchdog_control RECORD;
>   help RECORD;
>  BEGIN
>   LOOP
>    PERFORM * FROM watchdog_ctl;
>
>    IF NOT FOUND THEN
>     EXIT;
>    END IF;
>
>    PERFORM sleep(3);
>
>   END LOOP;
>   RETURN now();
>  END;
> ' LANGUAGE plpgsql;
>
> That means that I want to leave the loop if there isn't an entry in the
> table watchdog_ctl. This works fine if the table is empty at the startup of
> the function (select watchdog();). But if I empty the table watchdog_ctl
> while the function is running it seems to be an endless loop. Hay anyone of
> you an idea why??

What version are you using?  I believe in versions prior to 8.0, that
perform is going to see the same snapshot each time, which means it's not
going to see the effects of your delete.  The function seems to act as you
want in 8.1beta (can't test 8.0 right now).


In response to

pgsql-admin by date

Next:From: Thomas PundtDate: 2005-07-14 14:59:54
Subject: Re: Import Oracle to Postgres
Previous:From: Tom LaneDate: 2005-07-14 13:17:05
Subject: Re: functions vs stored procedures

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group