Re: Inserting a timed delay in a pl/pgsql procedure

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: John DeSoi <desoi(at)pgedit(dot)com>
Cc: Benjamin Krajmalnik <kraj(at)illumen(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Inserting a timed delay in a pl/pgsql procedure
Date: 2006-08-18 20:28:54
Message-ID: 20060818202854.GA79876@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Fri, Aug 18, 2006 at 03:50:02PM -0400, John DeSoi wrote:
> The only other solution I recall was to use a different pl language
> like perl which has a proper sleep function.

That's what I've done. 8.2 will have a pg_sleep() function so
writing your own will no longer be necessary.

http://archives.postgresql.org/pgsql-committers/2006-01/msg00187.php

--
Michael Fuhr

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Sriram Dandapani 2006-08-19 06:46:17 Re: dropping partitioned table waits forever
Previous Message Bruno Wolff III 2006-08-18 19:52:21 Re: Restoring database question..