Postgres Pro
Downloads
Home   >   mailing lists

Re: sleep function - Mailing list pgsql-sql

From Bruce Momjian
Subject Re: sleep function
Date
Msg-id 200408101457.i7AEvvc15187@candle.pha.pa.us
Whole thread Raw
In response to sleep function  (John DeSoi <jd@icx.net>)
Responses Re: sleep function  (John DeSoi <jd@icx.net>)
List pgsql-sql
Tree view 
John DeSoi wrote:
> Is there a sleep function of some kind? I wanted to simulate a query 
> taking a long time to execute for testing purposes.

I can't think of one, no.  I think you will have to use one of the
server-side languages and call a sleep in there.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073

pgsql-sql by date:

Previous
From: John DeSoi
Date:
Subject: sleep function
Next
From: Joe Conway
Date:
Subject: Re: function expression in FROM may not refer to other relations