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

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 (view raw or flat)
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

pgsql-admin by date

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

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