Postgres Pro
Downloads
Home   >   mailing lists

Re: SLEEP in posgresql - Mailing list pgsql-general

From Richard Huxton
Subject Re: SLEEP in posgresql
Date
Msg-id 470C8C3E.3060806@archonet.com
Whole thread Raw
In response to Re: SLEEP in posgresql  ("Jasbinder Singh Bali" <jsbali@gmail.com>)
Responses Re: SLEEP in posgresql  ("Jasbinder Singh Bali" <jsbali@gmail.com>)
List pgsql-general
Tree view 
Jasbinder Singh Bali wrote:
> What if its just SLEEP for 1 second. Why would it keep my stored procedure
> hanging ?

Because presumably your loop-condition isn't under your control
(otherwise you wouldn't need to sleep).

Can you *always* guarantee the condition (a=b) will happen within a
reasonable time-frame?

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Upper and Lower-cased Database names?
Next
From: "Jasbinder Singh Bali"
Date:
Subject: Re: SLEEP in posgresql